of course I did,
let me tell you how apache and php interact with php as far as I know:

I'm using php set up as a module for apache. so apache handles each
web page request and forwards the request to one of its threads (the
thread count is set up from httpd.conf). the algorythm it uses is
pretty much the same I described before "If there is an idle thread,
hand the request to that thread, else create a new thread"

So, each thread creates a persistent connection to mysql, regardless
of the connections created by the other threads.

Which at the end, comes to 'a persistent connection for every thread'
and this, I don't find very effective.

what I want to do is, get between apache and mysql, and handle every
connection request with a "resource dispenser".

regardless of the thread count, I want my dispenser handles connection
requests in the way apache handles web page requests: "If there is an
idle connection, use it. else create a new connection"


JG> Did you read the manual page?
JG> http://us4.php.net/manual/en/function.mysql-pconnect.php

JG> [quote]First, when connecting, the function would first try to find a
JG> (persistent) link that's already open with the same host, username and
JG> password. If one is found, an identifier for it will be returned instead of
JG> opening a new connection. [/quote]

JG> In practice it might not act like that though, it depends on your server set
JG> up.

>> -----Original Message-----
>> From: Mengü Gülmen [mailto:[EMAIL PROTECTED]
>> Sent: Wednesday, May 28, 2003 2:21 PM
>> Subject: [PHP-DB] connection pooling
>> Hi there,
>> I've been looking all over the net for connection pooling information
>> about php and mysql but I didn't come across anything.
>> Do you know anything like the connection pooling system of asp?
>> In php, there is the pconnect, persistent connection which, as far as
>> I know does nothing but open a connection and execute all the commands
>> via that connection.
>> What I want is, something that does this: "If there is no existing
>> connection or the existing connection is in use, open another
>> persistent connection. if there is an open connection and it's idle,
>> use that one"
>> If there is nothing that can do this, I'll start to try to write it on
>> my own. And of course, any help would be appreciated :)
>> --
>> Finest,
>> Mengü,
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to