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!

 

2 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