Axel Boldt wrote:
3) Assuming that php runs as an apache module, we
should use
persistent database connections. That way, we won't repeatedly send
over the username and password; one connection is reused by apache
even after the php script dies.
(
http://www.phpbuilder.com/manual/features.persistent-connections.php
and
http://www.phpbuilder.com/manual/function.mysql-pconnect.php)
After reading these two pages, it seemed that all I needed to do was change
mysql_connect in databaseFunctions.php to mysql_pconnect.
It's a little early to get *too* excited, but so far the results seem astonishing!
This is the first time I've seen the 5 minute load on the machine under 3 in days.
And it's 0.46 now.
Also, I'm getting 2.52 pages per second from my little benchmarking tool. This is
dramatically better than the 1/2 page per second pace we've been seeing.
--Jimbo