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, [EMAIL PROTECTED] 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: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > _____ > > -- /---------------------------------------------------------------------\ | Jeremy Portzer [EMAIL PROTECTED] trilug.org/~jeremy | | GPG Fingerprint: 712D 77C7 AB2D 2130 989F E135 6F9F F7BC CC1A 7B92 | \---------------------------------------------------------------------/
signature.asc
Description: This is a digitally signed message part
-- TriLUG mailing list : http://www.trilug.org/mailman/listinfo/trilug TriLUG Organizational FAQ : http://trilug.org/faq/ TriLUG Member Services FAQ : http://members.trilug.org/services_faq/ TriLUG PGP Keyring : http://trilug.org/~chrish/trilug.asc
