Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Load QVD from Redshift is very slow

Hi,

I am trying to create QVD from Redshift table. Table has 93 columns and 70m records. It is taking 2hrs of time. Is it possible to reduce the time.

Thanks

Anirban

1 Reply
marcus_sommer

You need a first to slice your table into smaller slices - most commonly are period-fields like years or yearmonth - and afterwards just to load the new/changed records with an incremental load-approach. Within the second half of the following posting you will find various examples on how to load data incremental and ensuring an optimized qvd-load with exists() on them:

Advanced topics for creating a qlik datamodel

- Marcus