Jon Slaughter wrote:
> Is it better to log in or out for each query or log in and stay logged in
> for all queries?
>
> It would be easier for me to log in and out for each query but I'm worried
> that this might cause excessive overhead in the future.
>
> Thanks,
> Jon
>
>

there is no problem with staying logged on if your design and setup
allows that.

however, each time you log out and back in, understand that a thread is
destroyed (hopefully explicitly by you but potentially implicitly by the
server) and a new one is created.

try to create some metrics and base your method on those metrics. mysql
can and does a good job of either of these methods.

--
lark -- hamzee@sbcdeglobalspam.net
To reply to me directly, delete "despam".