Re: MySQL close connection, what's the purpose?
| From: | Anthony Ettinger | Date: | Fri, 31 Mar 2006 23:34:45 +0000 |
| Subject: | Re: MySQL close connection, what's the purpose? | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-233024@lists.php.net to get a copy of this message | ||
On 3/31/06, chris smith <dmagick@gmail.com> wrote:
> On 4/1/06, tedd <tedd@sperling.com> wrote:
> > At 10:30 PM +0200 3/31/06, Martin Zvarík wrote:
> > >Hi,
> > > I was wondering why is it necessary to use
> > >mysql_close() at the end of your script.
> > >If you don't do it, it works anyways, doesn't it?
> > >
> > >MZ
> >
> > MZ:
> >
> > I always close the connection right after my
> > query -- force of habit. It's like leaving the
> > toilet seat up, it's only going to get you into
> > trouble.
>
> So you close it after every query and then re-open it later for the
> next query? I don't see that as a good idea.
>
No, you leave it open until you're done with the database.
If you pee and poo in one sitting, you don't get up and flush between
occurrences.
--
Anthony Ettinger
Signature: http://chovy.dyndns.org/hcard.html