Re: MySQL close connection, what's the purpose?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



tedd wrote:
chris said:

Just out of interest, could you re-run the test using persistent connections?

change mysql_connect to mysql_pconnect..

[snip]

Thanks -- does the "persistent connection" thing hold the server up until released? How does that work?

MySQL is threaded so will not be "held up" by any connection. Obviously the more connections the more of certain resources it will be using, but it doesn't block for every connection.

The exception, of course, being if you have something going on at the MySQL protocol level such as LOCK TABLES or a transaction. That will hold up certain other queries. But that's at a whole other layer.

--
Jasper Bryant-Greene
General Manager
Album Limited

http://www.album.co.nz/     0800 4 ALBUM
jasper@xxxxxxxxxxx          021 708 334

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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux