note 42599 deleted from features.persistent-connections by betz

From: 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'.

« previous php.notes (#69988) next »