Edit report at https://bugs.php.net/bug.php?id=63215&edit=1
ID: 63215
Comment by: james at kenjim dot com
Reported by: james at kenjim dot com
Summary: Add support for Firebird commit retaining
transactions.
Status: Assigned
Type: Feature/Change Request
Package: PDO related
Operating System: All
PHP Version: 5.4Git-2012-10-03 (Git)
Assigned To: mariuz
Block user comment: N
Private report: N
New Comment:
I have uploaded a new improved patch with Bug #63690 that includes the
functionality here. I suggest using that patch instead of the one I uploaded
here as that is a more complete solution and fixes some unexpected behavior if
someone uses commit retaining.
Previous Comments:
------------------------------------------------------------------------
[2012-10-04 00:01:51] james at kenjim dot com
Description:
------------
Add the ability to do commit retaining transactions using the Firebird PDO
driver. Commit retaining is faster when committing because it reuses server
transaction resources. The downside is you are still in the old transaction
context so you won't see any new concurrent commits. Commit retaining is
ideally used when you have lots of small transactions that do not rely on other
data that may be changed by another thread/user.
I have written a patch to add the ability to do commit retaining transactions
using
$dbh->setAttribute(PDO::FB_ATTR_COMMIT_RETAINING, true);
Any following commits or rollbacks will use their retaining equivalent after
this attribute is set. You can return to using normal commit and rollbacks by
setting the attribute to false.
$dbh->setAttribute(PDO::FB_ATTR_COMMIT_RETAINING, false);
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=63215&edit=1
