Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-06-12 05:19 PM

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!

 

Labels (2)
Labels
291 Views
0 Likes
3 Replies
David_Beaty
Specialist
Specialist
‎2018-06-13 05:11 AM

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

291 Views
0 Likes
Anonymous
Not applicable
‎2018-06-13 06:48 AM
Author

Hi,

 

 

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

291 Views
0 Likes
Anonymous
Not applicable
‎2018-06-27 04:28 AM
Author

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

291 Views
0 Likes