Re: [HACKERS] Re: PHPBuilder article -- Postgres vs MySQL

It is possible. I think the problems were arising before the currentpatch.
Problems involved not properly releasing conenctions and they were
eventually filling up as used.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
----- Original Message -----
From: "Charles Tassell" <ctassell(at)isn(dot)net>
To: "Adam Lang" <aalang(at)rutgersinsurance(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Wednesday, November 15, 2000 4:54 PM
Subject: Re: [HACKERS] Re: [GENERAL] PHPBuilder article -- Postgres vs MySQL

> 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.
>
>
> 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(at)randomnetworks(dot)com>
> >To: "carl garland" <carlhgarland(at)hotmail(dot)com>
> >Cc: <martin(at)math(dot)unl(dot)edu(dot)ar>; <RDNELSON(at)co(dot)centre(dot)pa(dot)us>;
> ><davidb(at)vectormath(dot)com>; <mfork(at)toledolink(dot)com>; <poulc(at)cs(dot)auc(dot)dk>;
> ><pgsql-general(at)postgresql(dot)org>; <pgsql-hackers(at)postgresql(dot)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(at)randomnetworks(dot)com joseph(dot)scott(at)owp(dot)csus(dot)edu |
> > > --------------------------------------------------------------------