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

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

 



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

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