note 42599 added to features.persistent-connections
| From: | ryan at netidea dot com | Date: | Sat, 22 May 2004 23:57:09 +0000 |
| Subject: | note 42599 added to features.persistent-connections | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-69975@lists.php.net to get a copy of this message | ||
The recommendations regarding persistent connections and transactions is really lame. The advice to
avoid using both at the same time is stupid. The database connection library should rollback all
open transactions and close all cursors when the script ends. The database connection should be in
a consistent and pristene state at the beginning of every script. To expect the user to clean all
that up is a little much.
Also every SQL statement should be executed in the context of a transaction, unless you are doing
read-only SELECTs without 'FOR UPDATE'.
----
Manual Page -- http://www.php.net/manual/en/features.persistent-connections.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+42599
Delete -- http://master.php.net/manage/user-notes.php?action=delete+42599&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+42599&report=yes
Search -- http://master.php.net/manage/user-notes.php