STT - Optimizing Qlik Cloud App Performance

[Troy_Raney]

This Techspert Talks session covers:

• App performance evaluation tools
• How to improve app performance
• Development best practices

Chapters:

1. 01:59 - Horizontal scaling
2. 03:06 - App Performance Evaluation tool
3. 05:29 - What tool to use
4. 05:54 - Where to get the App Analyzer
5. 06:53 - App Analyzer demo
6. 09:35 - App with poor performance
7. 10:39 - IF statements
8. 11:48 - Calculation Condition
9. 12:56 - Poor expression example
10. 13:36 - Improved Performance Evaluation
11. 14:34 - Improved App script
12. 16:28 - Improved App front-end
13. 17:54 - App Analyzer on improved app
14. 20:13 - Q&A: How many concurrent reloads in Cloud?
15. 21:04 - Q&A: What is the best data model for Qlik Answers?
16. 22:27 - Q&A: Why could the app size grow in Qlik Cloud?
17. 23:23 - Q&A: Do calculations perform better in the script?
18. 23:55 - Q&A: Can apps be pre-loaded in Qlik Cloud?
19. 25:05 - Q&A: Does a simpler data model improve performance?
20. 25:57 - Q&A: Do many users affect performance?
21. 27:03 - Q&A: Where is there performance documentation?
22. 27:28 - Q&A: What are performance best practices?

Resources:

• Qlik Cloud Monitoring Apps Workflow Guide
• Optimizing application performance

Q&A:

Q: We have apps that are really big (13gb in RAM). It has a lot of data (number of rows approximately 150M). Where to start?

A: If the app analyzer will run, I would start there and then look for areas that could be reduced (e.g. Date fields, keys that can be autonumbered, etc.).  If that does not work, I would suggest looking into reducing the amount of historical data the app contains (if possible), or moving towards an ODAG approach where users interact with a summarized set of data for the most part and spin up detailed apps of granular data when needed.

Q: We have an app more than 14 GB, how we can check with app analyzer?

A: If you have an application that is too large for the app analyzer, I would suggest reducing some of the history in order to be able to get the App Analyzer to run.  The insights you will find should be applicable to the full data set.

Q: Does using Bookmarks as default on app open will reduce the load time for the app?

A: Yes, this is a great way to speed up the opening load time for end users.

Click here to see transcript

@EamonnH 

[F_B]

Thank for the quick summary organization.