Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
We are on Feb 2024 Patch 7 and having Qlik Dashboard with Historical Data (File Size 2.40GB) and Base Memory Size (6.47 GB).
Dashboard is very slow while opening the Dashboard. Any Suggestion to Improve the Performance.
Look here for answers
Hi @atiwari ,
Following are some you can try:
- Split the app into two to reduce the size. Bifrication is the easiest and best option or think about optimizing the app
- You can use the precache option to open the app faster as its loaded already App preload - a cache warmer | Qlik Sense for developers Help
- Talk to your Account Manager and try a capacity planning so there is enough Hardware for the demand of growing data
- Dedicate a RIM node if the app is highly utilized and then we can create a security rule to open the app on this dedicated RIM node.
If you want a more detailed brakedown of what makes the app slow, then I can recommend this tool:
https://community.qlik.com/t5/Qlik-Sense-Documents/Qlik-Explorer-for-Developers/ta-p/1949809
Your app is relatively large, so I would expected that loading fields and tables are the most expensive parts, but there could be other things in the app that are problematic. And the app open progress information you can get from that tool can be very valuable when it comes to identifying bottle necks.
A few more useful links to consider
These 2 links are less relevant to a specific app, in which size or optimization is the most likely concern, but they are useful for more broad app open performance.
Improve app opening performance with ExcludeConnectionsOnOpenApp
How to disable 'Base memory size' info and 'StaticByteSize' calls in Qlik Sense
Though my go-to article is below, it is a large meta article with links to various articles for investigation performance concerns
How to start investigating Qlik Sense Performance and address high RAM usage