Hard Commit for TZConnection
Posted: 02.10.2005, 06:48
I had read the Zeos article about connecting the ZeosDBO with Firebird.
Now the feature request is, it should be hard commit if AutoCommit property for TZConnection is True, my reason is the Firebird engine will treat a transaction to be "interesting transaction" if only commit retaining and it will increase the garbage that cause the sweep must be done (sweep command will decrease performance of Firebird itself).
But I don't know the behaviour of other RDBMS (Oracle, MySQL, MSSQL, Postgres, Sybase). If the behaviour of the Firebird is not the same with other RDBMS that ZeosDBO supported, then it should be another property for TZConnection that developer can choose between hard commit or soft commit (commit retaining). Thank's
Now the feature request is, it should be hard commit if AutoCommit property for TZConnection is True, my reason is the Firebird engine will treat a transaction to be "interesting transaction" if only commit retaining and it will increase the garbage that cause the sweep must be done (sweep command will decrease performance of Firebird itself).
But I don't know the behaviour of other RDBMS (Oracle, MySQL, MSSQL, Postgres, Sybase). If the behaviour of the Firebird is not the same with other RDBMS that ZeosDBO supported, then it should be another property for TZConnection that developer can choose between hard commit or soft commit (commit retaining). Thank's