Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ani310_mitra
New Contributor III

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

Re: Load QVD from Redshift is very slow

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

Community Browser