Discussion board where members can get started with QlikView.
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.
Go to Solution.
*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
What Is QVD optimized and QVD un optimized
chk dis too
optimized qvd non optimized qvd
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.
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.
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.