Changing the Transaction behavior
Posted: 13.04.2008, 23:15
In Zeos with Auto Commit set to True a Transaction is started as soon as the connection is made and committed after that for every operation done(I think that is correct, not 100% sure there).
I was wondering what effect it might have to leave the transaction inactive(not calling StartTransaction) until an operation needs to be done against the database and then we commit the transaction(HardCommit in case of Firebird/Interbase).
If this can be done then we don't need to have a transaction active when nothing is done. The transaction is only started when needed.
Regards
Sandeep
I was wondering what effect it might have to leave the transaction inactive(not calling StartTransaction) until an operation needs to be done against the database and then we commit the transaction(HardCommit in case of Firebird/Interbase).
If this can be done then we don't need to have a transaction active when nothing is done. The transaction is only started when needed.
Regards
Sandeep