Discussion Board for collaboration related to QlikView App Development.
I am facing severe performance issues in one of the Grid reports. The grid report has complex calculations and multiple metrics.
The data volume is high 300 million rows (5 GB App Size), after applying all the standard best practices for Optimization.
Our server is 16 core, 128 GB RAM.
The Grid report takes 3 mins to render, while the RAM and CPU usage are <30% most of the time.
Question: Why does the report not take the available resources (RAM and CPU) and provide results quicker. What govern's the maximum CPU utilization.
Also, what can be done for optimization in such situations.
Any ideas, what could be happening here?