Dashboard performance issue

[jelly_gvm]

Hi All,

In my dashboard one of the report having 12 million records, how to improve the dashboard performance ? can any one help me.

Note :- For improving the performance, i have followed the below details

1. Removed unwanted tables and fields in the data model

2. Data model is STAR Schema

3. All calculations are done in the script not in reports.

4. My DEV server having 256 GB RAM and also 52% of RAM is free in the server, there no timeout problem.

Thanks in Advance

Regards,

Ram M

[daniel_kusiak]

Hi jelly_gvm

Try to use this tool - QV Document Analyzer. You can download it here: http://qlikviewcookbook.com/tools/

Maybe it will give you some insight.

[jelly_gvm]

Thanks for your kind reply, i have used the QV Document Analyzer, but still i'm having some performance issues.

Can you suggest me any other technique ?

Regards,

Ram M

[#4]

Hi Ram

I had encountered the similar problem where the data on the dashboard was delayed. I realized that the amount of the data that was showing on the dashboard  was not the usually required 99 % of time. I applied some default bookmarks on opening of the sheet and applied conditional statement on the chart which improved the user experience.

It could be something you could consider for better UI experience.

Thanks

[sunilkumarqv]

the only other technique is document chaining .

break the data into diff parts and create the chain

[robert_mika]

Are your tables saved in QVD's?

[jelly_gvm]

yes all the tables are saved in QVD's.