Five Stars

How to increment rows per second?

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!

 

3 REPLIES
Seven Stars

Re: How to increment rows per second?

Hi

 

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

 

Thanks

 

David

Regards

David

Don't forget to give Kudos when an answer is helpful or the solution.
Five Stars

Re: How to increment rows per second?

Hi,

 

 

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

---
Don't forget to give kudos when a reply is helpful.
Thanks
Moderator

Re: How to increment rows per second?

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.