9.15 Persistent connections: mysql_pconnect() and sqlite_popen()This is NOT the latest copy of this book; click here for the latest version.
resource mysql_pconnect ( [string server [, string username [, string password [, int client_flags]]]])
resource sqlite_popen ( string filename [, int mode [, string &error_message]])
Switching to persistent connections in MySQL is simply a matter of changing the function call from mysql_connect() to mysql_pconnect() - they both take the same parameters, with the difference being that mysql_connect() will always open a new connection, whereas mysql_pconnect() will only open a new connection if there is not one already available. Similarly, the SQLite function sqlite_open() has a persistent counterpart, sqlite_popen().
Author's Note: In the per-process Apache module ("prefork"), persistent resources such as persistent MySQL connections are stored per process, which means if you have 150 Apache children running you'll need 150 MySQL permanent connections - even if some of those processes aren't using MySQL right now.
|
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!
|
