Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Performance issue with Grid Report (CPU under utilized)

Hi All,

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.


Regards,

Diwakar

1 Reply
Highlighted
Creator
Creator

Any ideas, what could be happening here?