Qliksense Sales Application Performance issue

[Anonymous]

Hi All,

Our Sales application  size is 16 GB   but we have good Server configuration with 512 GB of RAM  and  Processor of 2.1GHz and 56 cores . there are  24 sheets in application  and To navigate between sheets takes  90 to 100 Seconds to completely load the data in each object of the sheet .

Suggest me  how to increase performance of Qliksense application .   I have converted all Date types to Number format and avoided If Condition as well

[CarmenReilly]

Hi Mahesh,

These resources may be helpful to you:

• Performance and Optimization Best Practices in QlikView & Qlik Sense: https://community.qlik.com/docs/DOC-17608
• The Qlik® Associative Engine memory management and CPU usage: https://www.qlik.com/us/resource-library/qlik-associative-engine-memory-management-cpu
• Qlik Sense® Performance Benchmark: https://www.qlik.com/us/resource-library/qlik-sense-performance-benchmark
• Qlik Sense Enterprise - Architecture and Scalability Technical White Paper: https://www.qlik.com/us/resource-library/qlik-sense-enterprise-architecture-and-scalability

You can also take a look at:

• Best Practices for Data Modelling: https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/DataModeling/best-practices-da...

I'm not sure how you're set up right now, but you could also look at loading from QVD files: https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/Scripting/work-with-QVD-files....

All The Best,

Carmen

[Anonymous]

Carmen Reilly

Hi Carmen Reilly,

Thank you so much, this point helps me for making better performance

• Performance and Optimization Best Practices in QlikView & Qlik Sense: https://community.qlik.com/docs/DOC-17608

[CarmenReilly]

Excellent, glad I could be of assistance!!

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.