I have an app that is loading into the App Overview slowly. I am looking to reduce the time it takes to open the app from the hub to getting to the App Overview screen (with all sheets loaded, ready for user selection). I am wondering others' thoughts on best practices for reducing that time solely to the app overview.
For reference the app I am working on currently has 27 sheets. Data Model has approx 25 million rows. The app size is 360 mb and has a RAM usage of 800 mb.
Some obvious thoughts I had:
-Reduce number of sheets
-Reduce model size (I am not sure how much the data model affects the load time from the hub to the app overview)
What are the biggest factors affecting the performance of loading the App Overview? Would splitting the app into a binary load improve this performance at all?
Would conditionally hiding sheets from the App Overview affect performance?
I'm very curious to hear others' thoughts on this since most performance optimization articles and threads are focused on slow performing sheets or visuals.
Move as much as possible to the load script ie: such as calculated columns, Leaving these in the app is known to cause performance hits.
Ensure your app is pristine. Fix or remove invalid calculation found in test or hidden sheets
Perhaps remove private sheets. Just keep the published sheets and sheet objects in the publish app. A quick way to do this is to export the app, then import it again (use update existing app check box if you wish to keep the same App ID)
Lastly, check the performance of your Qlik Sense server. Please check the following link for information therein and to ensure you are getting the most out of your hardware and to know if you need to add more.
Move as much as possible to the load script ie: such as calculated columns, Leaving these in the app is known to cause performance hits.
Ensure your app is pristine. Fix or remove invalid calculation found in test or hidden sheets
Perhaps remove private sheets. Just keep the published sheets and sheet objects in the publish app. A quick way to do this is to export the app, then import it again (use update existing app check box if you wish to keep the same App ID)
Lastly, check the performance of your Qlik Sense server. Please check the following link for information therein and to ensure you are getting the most out of your hardware and to know if you need to add more.
