Use Persistent Connections
If you connect to a database with each script, consider using a persistent connection rather than a normal connection. For MySQL users, that is the difference between using mysql_pconnect()
rather than mysql_connect()
. Persistent connections remain connected even after your script has ended, which means that the next time a script asks for a connection, it uses the one that is already openâthis saves a lot of time negotiating passwords and such that can otherwise be used to execute important code.
Switching to persistent connections does not require any other change than adding a "p" in the function nameâthe parameters are still the same. If your database server is not on the same machine as your web server, consider using CLIENT_COMPRESS
as the fifth parameter to your mysql_connect()
/mysql_pconnect()
call, as it allows MySQL to compress data to save space, and can drastically lower network bandwidth and transfer speed, particularly when reading in lots of data.
Get PHP in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.