topic Differemce between tMysqlConnection's Auto Commit and tMysqlCommit ? in Talend Studio

Differemce between tMysqlConnection's Auto Commit and tMysqlCommit ?

Anonymous — Sat, 16 Nov 2024 12:23:57 GMT

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

Thanks!

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

Anonymous — Tue, 07 Feb 2012 15:43:16 GMT

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.

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

Anonymous — Wed, 08 Feb 2012 07:42:50 GMT

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 ?

Anonymous — Wed, 08 Feb 2012 18:07:08 GMT

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