Persistent connections

As you know, PHP automatically cleans up after you whenever a script ends, and connections to databases are no different - you open a connection each time your script starts, and close it when the script finishes, which can be quite a speed hit. However, there is an alternative: persistent connections. These are opened by the first PHP script that requires them, and stay open across PHP scripts, thereby eliminating the need to constantly open and close database connections.

Many people have problems with persistent connections timing out unexpectedly, so you should try them out on a test server before implementing them on your site.

 

Want to learn PHP 7?

Hacking with PHP has been fully updated for PHP 7, and is now available as a downloadable PDF. Get over 1200 pages of hands-on PHP learning today!

If this was helpful, please take a moment to tell others about Hacking with PHP by tweeting about it!

Next chapter: Temporary Tables >>

Previous chapter: Indexes

Jump to:

 

Home: Table of Contents

Copyright ©2015 Paul Hudson. Follow me: @twostraws.