[TriLUG] mysql close statements

[Jeremy Portzer]

What language are you writing in ?  PHP?  Perl?  C?

In general, the database connection will be closed when the object goes
out of scope... but the meaning of that could be quite different
depending on the language and situation.  There are also ways to set up
persistent connections that don't open and close all the time, which can
be a performance problem.

--Jeremy

On Fri, 2004-02-20 at 11:00, spain at ncssm.edu wrote:
> I just wanted to get a opinion from the masses on close statements for
> mysql.. 
>  
> If you open a connection in an include file, run your query, and then
> display the results..
>  
>  Is it necessary to include a mysql close connection statement? Or will
> these open connections you create close out eventually?  Does it have any
> effect on mysql server if you don't close out the connection?
>  
> 
> 
> 
>   _____  
> 
> Sincerely,
> Jamil Hassan Spain
> NC School of Science and Mathematics | External Programs 
> Phone: 919-416-2641
> Web: www.dlt.ncssm.edu <http://www.dlt.ncssm.edu/> 
> Email: spain at ncssm.edu <mailto:spain at ncssm.edu> 
>   _____  
> 
>  
-- 
/---------------------------------------------------------------------\
| Jeremy Portzer        jeremyp at pobox.com      trilug.org/~jeremy     |
| GPG Fingerprint: 712D 77C7 AB2D 2130 989F  E135 6F9F F7BC CC1A 7B92 |
\---------------------------------------------------------------------/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
URL: <http://www.trilug.org/pipermail/trilug/attachments/20040220/e6a3abb5/attachment.pgp>