Req #63215 [Com]: Add support for Firebird commit retaining transactions.
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
Thread (4 messages)