Autocommit in mssql server connection dramatic decrease inser performance

[EV89]

Hi,

when i use the connector for mssql server output with autocommit option flagged the performance of CRUD operation dramatic decrease. For example an insert of 310 000 records pass from 8 seconds to 20 minutes.

Why this? any best practice to use the mssql connector component without decrease job efficiency?

thanks for your help

[gjeremy1617088143]

HI, in your tDbOutput component , did you use just insert or other option like "insert or update" ?

Couly you also specify your commit every size ?

Send me Love and Kudos