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
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
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: 
MaheswarReddy
Contributor III
Contributor III
‎2020-01-10 09:00 AM

Performance issue with MSSQL data loading to file

Hi Team,

 

I just have a simple one to one map from tMSSQLInput to tfileOutput (Simple one to one) Shown in the picture,

The time it takes is huge for to load directly into the file, Is there any way to improve performance ?

 

I can load only 2500 rows per second , Is there any way that i can improve performance ?

 

Please let me know.

 

Thanks

 

 

 

Labels (3)
Labels
246 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2020-01-10 01:26 PM

Hi,

 

    The first thing I would recommend is to verify the execution plan of the query to make sure that its optimal in nature. If it needs tuning, I would recommend to get the help of a DBA to tweak it before running it in Talend.

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

246 Views
0 Likes