If you are experiencing slow performance in a specific QlikView document, QlikView Optimizer can help you.
You can investigate which object is consuming the most memory within the document, and if it is significantly higher compared to others, then you may consider removing the object, avoid complex expressions or modifying data model.
Also, you can specify an estimate number of users to foresee how much RAM you may need for expansion of QlikView environment.
A .mem (memory statistic) file can be generated by QlikView files if specified. Make sure to interact with objects (open minimized objects, make selections etc) before a .mem file is saved. You can save a .mem file in
Settings >> Document Properties >> General Tab >> Memory Statistics...
The memory statistic file allows you to capture the behaviors of each QlikView document. QlikView Optimizer can read more than one mem file so that you can compare multiple QlikView document behaviors. And from the result, you may modify your QlikView documents for better performance!
QlikView Optimizer lets you monitor Bytes, Count, Size, CalcTime, AvgCalcTime etc.
Take a close look at "bytes" column in Actual Usage tab to find out which object or field is costing the most memory.
* Once the file paths are specified, go to File >> Reload to read your files.