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
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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: 
sushantk19
Creator
Creator
‎2020-10-05 07:58 AM

Improving the data load speed to Amazon redshift database

hello Team,

I have a daily job which loads ~6 million data daily(truncate reload). My target database if Amazon redshift. I have used tRedshift_output as the output component. presently the jobs takes somewhere between 4 to 5 hrs to complete. Is there a way to improve the performance of this job? Can i use any other component to improve the performance. My source is a little complex SQL ( 4 full outer join statements)

2,194 Views
0 Likes
20 Replies
sushantk19
Creator
Creator
‎2020-10-29 06:54 AM
Author

In response to pakapi_

@Kamil Kowalczyk​ : it is coming as disabled even if select the GZIP option. But yes, GZIP did help me a lot to reduce the time. there is a 50% reduction in my load time now, which is good. Do you know how to enable this option? "Enable parallel execution". It is disabled right now for me. Please see the screenshost attached.

151 Views
0 Likes