https://community.qlik.com/t5/Talend-Studio/Autocommit-in-mssql-server-connection-dramatic-decrease-inser/m-p/2351031#M117762 <P>HI, in your tDbOutput component , did you use just insert or other option like "insert or update" ?</P><P>Couly you also specify your commit every size ?</P><P>Send me Love and Kudos</P> Mon, 28 Jun 2021 07:41:14 GMT gjeremy1617088143 2021-06-28T07:41:14Z https://community.qlik.com/t5/Talend-Studio/Autocommit-in-mssql-server-connection-dramatic-decrease-inser/m-p/2351030#M117761 <P>Hi,</P><P></P><P></P><P>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.</P><P></P><P></P><P>Why this? any best practice to use the mssql connector component without decrease job efficiency?</P><P></P><P></P><P>thanks for your help</P><P></P><P></P><P></P><P></P> Sun, 27 Jun 2021 14:12:00 GMT https://community.qlik.com/t5/Talend-Studio/Autocommit-in-mssql-server-connection-dramatic-decrease-inser/m-p/2351030#M117761 EV89 2021-06-27T14:12:00Z https://community.qlik.com/t5/Talend-Studio/Autocommit-in-mssql-server-connection-dramatic-decrease-inser/m-p/2351031#M117762 <P>HI, in your tDbOutput component , did you use just insert or other option like "insert or update" ?</P><P>Couly you also specify your commit every size ?</P><P>Send me Love and Kudos</P> Mon, 28 Jun 2021 07:41:14 GMT https://community.qlik.com/t5/Talend-Studio/Autocommit-in-mssql-server-connection-dramatic-decrease-inser/m-p/2351031#M117762 gjeremy1617088143 2021-06-28T07:41:14Z