Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
diwakarnahata
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
diwakarnahata
Creator
Creator
Author

Any ideas, what could be happening here?