Re: FN-FORUM: Closing Sleeping Connections of Mysql Using ASP....

date posted 22nd January 2004 12:57

> > I don't think you should worry too much
> > http://uk.php.net/manual/en/function.msql-pconnect.php
>
>
> It kind of depends. I've seen more than one raging argument over
> whether to use pconnect or connect with PHP/MySQL. In theory
> pconnect should give the best and most efficient results for the
> average case, but I've heard of various situations where using
> pconnect caused the connection pool to get exhausted prematurely;
> switching to connect resolved the problem at a stroke.

I meant that he didn't really have to worry in relation to the original
point, which I'd assumed (perhaps wrongly) was about creating db connection
objects and storing them in a session.

> I wasn't particularly convinced until a site I did just before
> Christmas had a busy day and hit the connection limit when it
> shouldn't. As a trial I switched to connect for that site, and since
> then it has been fine ...
>
> Defies the docs and common sense, but allegedly is a "known" issue to
> consider.

We've also had problems with 'pconnect' but in different circumstances - we
had problems with it in a shared hosting environment, which is perhaps
understandable, and switched back to 'connect' which has been fine since.

Andy