note 42599 deleted from features.persistent-connections by betz
| From: | betz@php.net | Date: | Sun, 23 May 2004 09:16:52 +0000 |
| Subject: | note 42599 deleted from features.persistent-connections by betz | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-69988@lists.php.net to get a copy of this message | ||
Note Submitter: ryan@netidea.com
----
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'.