|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Request #63215 Add support for Firebird commit retaining transactions.
Submitted: 2012-10-04 00:01 UTC Modified: 2018-07-06 19:06 UTC
Avg. Score:4.0 ± 0.0
Reproduced:1 of 1 (100.0%)
Same Version:0 (0.0%)
Same OS:0 (0.0%)
From: james at kenjim dot com Assigned:
Status: Duplicate Package: PDO Firebird
PHP Version: 5.4Git-2012-10-03 (Git) OS: All
Private report: No CVE-ID: None
 [2012-10-04 00:01 UTC] james at kenjim dot com
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);


CommitRetaining (last revision 2012-10-04 00:02 UTC by james at kenjim dot com)

Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2012-11-23 13:21 UTC]
-Assigned To: +Assigned To: mariuz
 [2012-12-05 07:22 UTC] 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.
 [2016-08-29 14:29 UTC]
-Package: PDO related +Package: PDO Firebird
 [2017-10-24 06:45 UTC]
-Status: Assigned +Status: Open -Assigned To: mariuz +Assigned To:
 [2018-07-06 19:06 UTC]
-Status: Open +Status: Duplicate
 [2018-07-06 19:06 UTC]
According to the @james comment, this ticket is now superseded.

PHP Copyright © 2001-2021 The PHP Group
All rights reserved.
Last updated: Sun Jan 17 06:01:22 2021 UTC