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

chris said:

Just out of interest, could you re-run the test using persistent connections? change mysql_connect to mysql_pconnect..

In doing so, the overall results dropped from a tenth of a second difference between both methods to three-one-hundredths of a second difference. In other words, using mysql_pconnect is three times faster for multiple open/closes. However, this only improved the connect/get-data/close sequence. The open once and keep open showed no improvement. Thanks -- does the "persistent connection" thing hold the server up until released? How does that work? tedd -- -------------------------------------------------------------------------------- http://sperling.com