Solved: how to improve qv loading speed - Qlik Community

vikasmahajan · ‎2016-10-10

Dear All,

I have qvw which loading 2 types of load 1.Daily 2. Nightly -> Nightly is full reload , and daily is current data reload while reloading daily we are concatenating history records which are big size approx 230,078,097 nos (Reload frequency is 10 mins) So I want to avoid loading such a big record sets again and again I want this records should load once' in qvw and remain as it is and current data can be concatenated with this records

Any thoughts , Idea's Please share .

Thanks in adv

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

marcus_sommer · ‎2016-10-10

I think I would put the nightly full-load into a qvw and load them binary into another qvw and then concatenate to them the daily data from qvd's.

Beside this I suggest to ensure that really all included fields are needed (take a look to the Document Analyzer V3.0 Update Available from Rob) and if there are possibilities to reduce the cardinailty from some fields: The Importance Of Being Distinct.

- Marcus

View solution in original post

marcus_sommer · ‎2016-10-10

I think I would put the nightly full-load into a qvw and load them binary into another qvw and then concatenate to them the daily data from qvd's.

Beside this I suggest to ensure that really all included fields are needed (take a look to the Document Analyzer V3.0 Update Available from Rob) and if there are possibilities to reduce the cardinailty from some fields: The Importance Of Being Distinct.

- Marcus