note 19407 added to function.mysql-pconnect
| From: | bartek at bulzak dot com | 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