Forum

Performance Issue with group By reports

18 June, 2015

Hi,

I am facing performance issue with Group By reports. Reporting Displaying takes long time if number of groups/data are more like(1300 groups and 8200 records) or (15 groups and 80000 records) .
Query execution is pretty fast. But displaying Data on browser taking long time if number of groups/data are more. If I remove the group from group by sections, then its displaying in seconds

IE and FireFox are taking very long time than chrome and hangs the reports. For somecases, in IE browser,the sub reports stays in processing mode even after displaying the data and also the tabs are not clickable then.

How do I configure the number of rows per page for Group By reports or is there any other way to configure to get it fast.

Thanks for your help.

Thanks & Regards
Jhansi

Hello Jhansi,

Although the performance issues may be something to do with how the report is set up, have you checked your memory settings as per this Forum Post?
Suggestion is to increase max memory to 1024 Mb, if not set to that already.