Re: [PHP4BETA] Database Connection Pooling
| From: | Manuel Lemos | Date: | Thu, 02 Mar 2000 07:39:28 +0000 |
| Subject: | Re: [PHP4BETA] Database Connection Pooling | ||
| References: | 1 | Groups: | php.version4 |
| Request: | Send a blank email to php-version4+get-11316@lists.php.net to get a copy of this message | ||
Hello php,
On 01-Mar-00 18:19:53, you wrote:
>> If that is what it was meant, I don't think it is a good idea. One
>> persistent connection per process is better than have Apache processes
>> competing for database connections allocated from a common pool. The way I
>> see it, that would impose needless latency in database connections.
>---I disagree. For running 1 web server for a site, it's probably just fine
>to have 1 persistent connection per apache process. But in my case, my
>web site is actually multiple machines that are behind a local director.
>I only have 1 database, so having 1 persistent connection for each apache
>process is murder. n boxes * 64 apache process = a LOT of persistent
If you are that low on resources, it doesn't make much sense to have that
much Apache processes ready, don't you think?
>connections. So if you had the ability to multiplex your persistent
>connections on 1 machine, then the overhead is desired in this case. So you
>could allocate
>(for example) 10 persistent connections per machine. So having 20 web
>servers is doable.
Is there an actual limit of opened connections to the database?
Regards,
Manuel Lemos
Web Programming Components using PHP Classes.
Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org
--
E-mail: mlemos@acm.org
URL: http://www.mlemos.e-na.net/
PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
--