note 42599 added to features.persistent-connections

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

« previous php.notes (#69975) next »