topic Re: How to increment rows per second? in Talend Studio

How to increment rows per second?

Anonymous — Tue, 12 Jun 2018 21:19:42 GMT

Hi, im currently grabing data from a mssql server and importing it to aurora, the problem is that the speed of the transfer is so slow its currently going 4.11 rows/s is there a way to increase that? im not doing any big jobs just a connexion from one db to another and a query that grabs all the data.

Thanks!

Re: How to increment rows per second?

David_Beaty — Wed, 13 Jun 2018 09:11:12 GMT

Are you sure you are inserting in batches? Also, do you have the Output component set to "Insert" mode not insert/update?

Thanks

David

Re: How to increment rows per second?

Anonymous — Wed, 13 Jun 2018 10:48:48 GMT

Hi,

Can you try using tELTMSSQLinput->tELTMSSQLMap->tELTMSSQLOutput ? it should also help increase in performance reducing execution time?

Re: How to increment rows per second?

Anonymous — Wed, 27 Jun 2018 08:28:12 GMT

Hello,

What does your query look like? The rate of 4.11 rows/s is not normal. Posting your issue with screenshots will get more visibility and more help.

Best regards

Sabrina