9.1.11 Persistent connectionsThis is NOT the latest copy of this book; click here for the latest version.
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 see this stuff in print? PHP in a Nutshell takes the core topics covered here, adds in thousands of edits from the editorial team and myself, and combines them to make an unbeatable reference for PHP programmers at all levels.
My latest book has hundreds more tips on how to use PHP, Apache, and MySQL, plus Perl, Python, shell scripts, performance tuning, and more!
|
