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.
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?
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
