note 34715 deleted from function.ibase-commit by abies
| From: | abies@php.net | Date: | Mon, 01 Sep 2003 22:37:22 +0000 |
| Subject: | note 34715 deleted from function.ibase-commit by abies | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-55446@lists.php.net to get a copy of this message | ||
Note Submitter: a.k.biesheuvel@its.tudelft.nl
----
Taken from the InterBase 6 API guide (page 75):
"Even transactions started with an access mode of isc_tpb_read should be ended with a
call to isc_commit_transaction() rather than isc_rollback_transaction(). The database
is not changed, but the overhead required to start subsequent transactions is greatly
reduced."
This suggests that committing transactions with only SELECT-statements is also preferable
over rolling them back.