RE: [HACKERS] Re: PHPBuilder article -- Postgres vs My SQL

I have had the same experience with PHP4, pg7 and persistent connections.

> -----Original Message-----
> From: Adam Lang [SMTP:aalang(at)rutgersinsurance(dot)com]
> Sent: Thursday, November 16, 2000 12:30 PM
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [HACKERS] Re: [GENERAL] PHPBuilder article -- Postgres
> vs MySQL
>
> Basically, after so many people connect and disconnect, the PHP doesn't
> reuse/drop old connections so you maximum amount is reached. You'd get to
> the point where no one is connected, but one another person would try to
> and
> it would come back with an error saying no connections available.
>
> I am unaware if anything has been posted to PHP about it.
>
> Adam Lang
> Systems Engineer
> Rutgers Casualty Insurance Company
> ----- Original Message -----
> From: "Frank Joerdens" <frank(at)joerdens(dot)de>
> To: "The Hermit Hacker" <scrappy(at)hub(dot)org>
> Cc: "Charles Tassell" <ctassell(at)isn(dot)net>; "Adam Lang"
> <aalang(at)rutgersinsurance(dot)com>; <pgsql-general(at)postgresql(dot)org>;
> <scherf(at)ventasoft(dot)de>
> Sent: Thursday, November 16, 2000 1:08 PM
> Subject: Re: [HACKERS] Re: [GENERAL] PHPBuilder article -- Postgres vs
> MySQL
>
>
> > The Hermit Hacker wrote:
> > >
> > > On Wed, 15 Nov 2000, Charles Tassell wrote:
> > >
> > > > Just a note, I've been using Postgres 7.02 and PHP 4.02 or 4.03 for
> about a
> > > > month in a couple sites, and haven't experienced any problems with
> > > > persistent connections. Problem might have been fixed in one of the
> point
> > > > releases, or maybe I just don't have enough different db connections
> to
> > > > trigger it.
> > >
> > > I run PHP4 and IMP (http://www.horde.org) and we've gotten then to
> remove
> > > the useof pg_pconnect() since it is broken. Broken how, you might
> > > ask? Well, I ran on a standalone machine, no other web users but
> myself,
> > > to test, and each tim eI hit the database with IMP,. it opened a new
> > > backend, but it never reused old, idle ones ... eventually, you run
> out
> of
> > > the ability to connect since you've locked up all connections ...
> >
> > That sounds pretty evil. Have you also tested PHP3 by any chance? Has
> this
> been posted to
> > php-general? If this is a general issue, it would have to be considered
> a
> _very_ nasty bug
> > indeed. Can you describe how you made the test, i.e. how you saw that it
> wouldn't reuse
> > idle ones and keeps opening new ones? How would you monitor this?
> >
> > - Frank