topic Re: Optimised load in QlikView

Optimised load

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

Hi experts ,

I have one application which took 45 min to reload .I have optimised app but still I feel it can be optimised more and reduce application reload time less.Please suggest me is there any chance to optimised the application.

Regards,

rup.

stalwar1‌jagan‌

Re: Optimised load

sunny_talwar — Mon, 31 Jul 2017 16:20:42 GMT

Look here for ways to do optimized qvd loads

https://www.quickintelligence.co.uk/qlikview-optimised-qvd-loads/

Re: Optimised load

neelamsaroha157 — Mon, 31 Jul 2017 16:37:03 GMT

You can replace most of your left joins with mapping.

Didn't call all the mapping tables here in the example but you call them at their appropriate places and check if the load time gets reduced. I am sure still there is room for more optimization.

Re: Optimised load

Nagaraju_KCS — Mon, 31 Jul 2017 18:14:51 GMT

Hi,

Script Level:

* Hold the synthetic keys to a minimum. Remove unnecessary links and joins tables explicitly in the script.

* If a reloads takes a great deal of time, use a binary load of static historical data.

* Drop tables from memory in the script once they have fulfilled their role.

* Use the AutoNumber() function to create a compact memory representation when using a complex composite key.

UI Level (layout):

* The memory used by objects and calculation times can be maintained in the sheets tab of the document properties. A good way to find bottlenecks in the application.

* Minimized charts do not take up memory. Uses the auto minimize option with charts that do not need be displayed at the same time.

* Force the user to make a selection before a large chart is displayed to reduce chart calculation times.

* Use appropriate messages while charts are being calculated.

* Avoid long expression with multiple string comparisons.

* Avoiding showing frequencies in Listboxes where not necessary.

PFA....