RE:Perfomance

[Chanty4u]

Hi,

what are the sollutions to increase the perfomance of the dashboard,..?

can any one help me on this...any procedure to follow?or there are any steps please let me know.

Thank you

Suresh

[Clever_Anjos]

First of all, which bottlenecks are you experiencing?

1. Reload time?
2. Memory comsumption?
3. CP?
4. Slow response time in your dashboard?

[ogster1974]

Some ideas...

Make sure your data model is in a star or snowflake schema.

Minimise use of Data islands

Avoid Synthetic keys

Only bring through the fields you are using in the Dashboard.

Only bring through the data that is relevant to the Dashboard.  If they are only interested in Last 2 years data don't bring through historical.

Hope this helps

Regards

Andy

[Clever_Anjos]

Recommended reading: Performance

[Chanty4u]

thank u fr response

i want reload time and memory consumption?Clever Anjos

[Clever_Anjos · Accepted solution]

Reload time is affected by how much data you are loading and how this data is loaded,

usually:

(slower) Databases time > Text files > QVD Files (faster)

I recommend you using Tools | Qlikview Cookbook "Script Log Analyser" in order to identify which steps of your script are slower

Memory comsumption is affected mainly by your data model (Search community for "Data Model")

I recommend you using Tools | Qlikview Cookbook "QV Document Analyzer" which objects are taking more time to render

And of couse, thanks rwunderlich‌, for sharing so usefull tools

[pratap6699]

use QVD files,using caliculated fields in script level,finally construct STAR datamodel,using variables,avoid macros,use container object,use set expressions instead of if condition