Re: [HACKERS] Re: PHPBuilder article -- Postgres vs MySQL - Mailing list pgsql-general

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 ...



 > >
> At 02:05 PM 11/15/00, Adam Lang wrote:
> >PHP 4 was having problems with persistent connections (not sure if with just
> >pgsql or all dbs).  Maybe that is why they didn't use it.
> >
> >Adam Lang
> >Systems Engineer
> >Rutgers Casualty Insurance Company
> >----- Original Message -----
> >From: <joseph@randomnetworks.com>
> >To: "carl garland" <carlhgarland@hotmail.com>
> >Cc: <martin@math.unl.edu.ar>; <RDNELSON@co.centre.pa.us>;
> ><davidb@vectormath.com>; <mfork@toledolink.com>; <poulc@cs.auc.dk>;
> ><pgsql-general@postgresql.org>; <pgsql-hackers@postgresql.org>
> >Sent: Wednesday, November 15, 2000 12:28 PM
> >Subject: Re: [HACKERS] Re: [GENERAL] PHPBuilder article -- Postgres vs MySQL
> >
> >
> > >
> > > On Wed, 15 Nov 2000, carl garland wrote:
> > >
> > > # >perhaps why, even at 5 clients, the page views he shows never went
> > > # >significantly above 10/sec?
> > > #
> > > # I think alot of it has to do with the web server/db setup not pg.  They
> >are
> > > # using Apache/PHP and looking at their code every page has the additional
> > > # overhead of making the db connection.  Now if they had used AOLserver
> >with
> > > # its persistent db connecction pooling scheme they may have faired better
> >;)
> > >
> > > I haven't actually looked at their code they used to test with to
> > > see if they are actually using it, but Apache/PHP has the ability to do
> > > persistent db connections.  I would be surprised that someone like Tim (
> > > who seems to have done a fair bit of php with db stuff) would not make use
> > > of such a feature.
> > >
> > > If you can point out an example of where they are not using this
> > > feature I will gladly stand corrected.
> > >
> > > --------------------------------------------------------------------
> > > | Joseph Scott                       The Office Of Water Programs  |
> > > | joseph@randomnetworks.com          joseph.scott@owp.csus.edu     |
> > > --------------------------------------------------------------------
>
>

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org