One Star

Differemce between tMysqlConnection's Auto Commit and tMysqlCommit ?

Is there any difference between using a tMysqlConnection with 'Auto Commit' on and using the tMysqlCommit component?

Thanks!
3 REPLIES

Re: Differemce between tMysqlConnection's Auto Commit and tMysqlCommit ?

yes. auto commit will commit after every insert statement (and is slower because of this). using a tMysqlConnection/tMysqlCommit set of components will allow you to control when data is commited.
One Star

Re: Differemce between tMysqlConnection's Auto Commit and tMysqlCommit ?

So basically if I've a table from which I'm moving data to another table, and I've about 10,000 rows, it's the difference between a single commit and 10,000 commits?

Re: Differemce between tMysqlConnection's Auto Commit and tMysqlCommit ?

auto commit can be changed according to the advanced section of the output (Number of rows per insert)
tMySQLCommit is used if you need to commit on a condition and rollback when the condition is not met either that or there is a problem when outputing the data
for instance tMySQLOutput -on Component ok-> tMySQLcommit
-on Component error -> tMySQLrollback
Regards
Brandon