This forum is now out of date, for our new forum Click Here
Performance Issue with group By reports
Question Asked
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

Jhansi

Thu Jun 18, 2015 1:52 PM

Comment
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.

Let me know if the issues are continuing, and I'll assist further.

Kind Regards,

Danny

Danny

Thu Jun 18, 2015 4:13 PM

Comment
Hi Danny,

Thanks for the Information. Below are our memory settings:
JVM max memory: 7.1 GB
Otherwise, from: appserver/bin/catalina.sh
JAVA_OPTS="$JAVA_OPTS -XX:PermSize=64m -XX:MaxPermSize=256m"
Do we need change the Xmx option to 1024m?

Thanks & Regards
Jhansi

guest

Mon Jul 6, 2015 1:17 PM