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