View Single Post

   
  #5 (permalink)  
Old 02-28-2008, 09:48 AM
Jerry Stuckle
 
Posts: n/a
Default Re: Better to login/out for each query?

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
>
>


Jon,

If you're talking web access, on a single page it's definitely better to
login before your first query and no log out until after your last query
(within the same page, of course).

For non-web-based languages, it all depends on just how often you need
the info and what modules require it. Generally I only open one
connection and close it between user interfaces.

Just never keep a connection open while the user is contemplating his navel.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Reply With Quote