mssql update/insert very slow

Six Stars

mssql update/insert very slow

I am updating/insert data from flat file to mssql database.
flatfileinput->tmap-mssqloutput
It is very slow. 5.9 rows/s.
Is there any suggestion or idea on this issue?
Thanks!

Re: mssql update/insert very slow

Talend will do a SELECT COUNT(*) with the WHERE based on the columns you have selected as the update key. If these columns are not indexed, or a query like that preforms poorly, that could explain the slowness.
Usually its a good idea to make the insert/update decision in a tMap and then do batches of updates and inserts independently.
Six Stars

Re: mssql update/insert very slow

Thanks for the reply. I will check the index.
Can you explain a little bit more in detail about how to make the insert/update decision in a tMap and then do batches of updates and inserts independently?
Thanks for your help.