Re: [PHP4BETA] Database Connection Pooling

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

« previous php.version4 (#11316) next »