I have fact table which is having almost 200 millions of records and almost 12 dimensions joining with with this table. With tables prepared data model and dash board. It is taking long time to open dashboard and charts.
Is there any way to increase the performance of loading records into dash board.
And also how to increase(taking long time to open) the opening time of charts.
Deep dig to your QlikView App using listed below ways and with attached App,
1st way:
You can check that which object on which sheet is consuming more memory. So, here is the way:
Open your QlikView App > Menu > Settings > Document Properties (Ctrl + Alt + D) > Sheets > Memory (check memory).
2nd way:
Open your QlikView App > Menu > Settings > Document Properties (Ctrl + Alt + D) > General > Memory Statistics (Export your File, you can export that file text format as well) > Open exported file in Notepad (check complete detail).
Analyzing Exported File "Memory Statistics" in QlikView:
Kindly find attached App for analyzing your exported file "Memory Statistics".
