Re: [Phplib-users] pgsql - too many clients?

[Roberto M. <rm...@cc...>]

On Wed, Nov 21, 2001 at 05:46:00PM +0100, Matthias Mohr wrote:
> 
> if you really need the performance you gain using pconnect instead of connect
> (especially when your database is running on another host, than you webserver)
> another approach could be setting the apache-config-value for
> MaxRequestsPerChild.

But the PHP documentation says that using pconnect PHP "reuses" the
connection. If this is solely an Apache issue, then I don't see how PHP
can make that claim.

This pconnect issue is very significant for the overhead of connecting to
a DB can be significant. In PostgreSQL, besides the savings in connection 
time, you save time when you are using stored functions because they are
compiled and cached (including execution plans for queries within the
functions) on each backend. So if the backends didn't die (e.g. the
connections were _in fact_ pooled and reused) you have a performance gain.

AOLserver got polled reusable connections to databases right in 1995. No
wonder I see so much better results under it than Apache.

-Roberto
-- 
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+
  Roberto Mello - Computer Science, USU - http://www.brasileiro.net 
       http://www.sdl.usu.edu - Space Dynamics Lab, Developer    
let length(Long_Walk) > length(Short_Pier)