note 19407 added to function.mysql-pconnect

From: Date: Tue, 26 Feb 2002 19:37:45 +0000
Subject: note 19407 added to function.mysql-pconnect
Groups: php.notes 
Request: Send a blank email to php-notes+get-27082@lists.php.net to get a copy of this message
PHP 4.1.1 running with Apache under Linux doesn't seem to be doing all necessary flushing when handling persistant mysql connections. Try it out for yourself. Create a temporary table in a pconnect session, add rows (non unique), select/display and drop the table. Now reload your script multiple times, you will see that your results are not consistent, even though you are creating a new table everytime and dropping it.. I had my share of problems with pconnect and suggest you don't use it unless absolutely necessary. In that case make sure you test your results for consistency, especially when your queries involve temporary tables or mysql session variables. Bartek Bulzak -- http://www.php.net/manual/en/function.mysql-pconnect.php http://master.php.net/manage/user-notes.php?action=edit+19407 http://master.php.net/manage/user-notes.php?action=delete+19407 http://master.php.net/manage/user-notes.php?action=reject+19407

« previous php.notes (#27082) next »