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

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@album.co.nz 021 708 334