Re: [PHP-DEV] $$Need apache server database pool....$$ From: Andreas Karajannis (Andreas.Karajannis <email protected>)
Date: 07/20/00

Eric Peters wrote:
>
> Checkout the thread on the php-general mailing list with regard to
> "Large PHP/Database driven site & scalability" but anyhow I need to have
> connection pooling integrated into the mysql_pconnects in an apache/php
> module environment instead of the current apache child based pool -
> If i can get confirmation on the possibility of it, and
> how long it would take I would enjoy looking into financing the
> development of it - and I've seen threads all over the php mailing list of
> people asking for it - I'm sure its possible to start a combined pool for
> the funding as well
>
Hi Eric,

I have written a connection pooling module for PHP, as it was something
I always wanted to have. This only works with threaded Webservers, I've
tested it with AOLServer.

To have connection pools in the current Apache multiprocess environment
would imply to set up a separate daemon process, define a communications
protocol between apache/PHP and the daemon etc.

IMHO this is would be a very "expensive" task, and would in itself add
another layer between your application and the database thus eating up
some (all?) of the advantages gained by connection pooling.

Another thing is the upcoming multithreaded apache (maybe this year?)
that could easily make use of database connection pooling - according to
Murphy's law you'd have a connection pooling daemon ready just when
Apache 2 gets out and obsoletes it ;-)

-Andreas 

-- 
Andreas Karajannis
GMD National Research Center for Information Technology
Schloss Birlinghoven, D-53754 Sankt Augustin
Phone +49 2241 142948

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>