topic Re: Optimize Non Optimize Qvd in QlikView

Optimize Non Optimize Qvd

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hey Community,

I have Script that load 7M rows.

When i load from the DB i save the data as is whit no manipulation on the data direct to qvd file via "STORE INTO Function"

when i load the QVD file i see that my load is non optimize because i use where/ Date Function.

Can anyone have a good tip how to create the data and load it optimize.

Thx

Re: Optimize Non Optimize Qvd

Chanty4u — Thu, 14 Apr 2016 11:59:45 GMT

chk dis

QVD Optimized

What Is QVD optimized and QVD un optimized

Re: Optimize Non Optimize Qvd

avinashelite — Thu, 14 Apr 2016 12:00:50 GMT

*Try to add all the conditions in the SQL and fetch only the required data to Qlikview and store the same into QVD

*After fetching all the data to Qlikview , create resident table and apply all the necessary conditions and then finally store the resident table as QVD and import the same

Hope this helps you

Re: Optimize Non Optimize Qvd

Chanty4u — Thu, 14 Apr 2016 12:00:57 GMT

chk dis too

Optimized QVD

optimized qvd non optimized qvd

Re: Optimize Non Optimize Qvd

marcus_sommer — Thu, 14 Apr 2016 12:03:39 GMT

I think you should make such small transforming within a Preceding Load and store it then as qvd. Afterwards you could load these qvd without transformings and you will get an optimized load.

- Marcus

Re: Optimize Non Optimize Qvd

ramasaisaksoft — Thu, 14 Apr 2016 13:34:34 GMT

hi David,

Case1:-if it is possible you can create a separate table (Apply all where conditions here)with all conditions at ETL process itself.

and fetch the data from new table.

Case2:-

Fetch the data from the original table apply where conditions,

create a separate table using RESIDENT Load and STORE this new table into your QVD .at last drop the first table

My self i will prefer Case2.