Req #63215 [Asn->Opn]: Add support for Firebird commit retaining transactions.
Edit report at https://bugs.php.net/bug.php?id=63215&edit=1
ID: 63215
Updated by: kalle@php.net
Reported by: james at kenjim dot com
Summary: Add support for Firebird commit retaining
transactions.
-Status: Assigned
+Status: Open
Type: Feature/Change Request
Package: PDO Firebird
Operating System: All
PHP Version: 5.4Git-2012-10-03 (Git)
-Assigned To: mariuz
+Assigned To:
Block user comment: N
Private report: N
Previous Comments:
------------------------------------------------------------------------
[2012-12-05 07:22:02] james at kenjim dot com
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.
------------------------------------------------------------------------
[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
Thread (4 messages)