Using PRD 5.0.6, With MsSql database
We have created report with drill-down and fetching the drill-down report, appx more then 5000 records in the report and using 3 sub-reports, group by function, concatenate and HTML pagination viewer. Seems to see report taking to much time for loading appx. more 5mins. But back-end query is executing with in 5-7 sec.

Pentaho server is severing the reports after 5-6 min. All BI-server optimizing configuration has been completed(CATALINA_OPTS=-Xms4g -Xmx10g -XX:MaxPermSize=1024m -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000)

pentaho installed on the Intel(R) Xeon(R) CPU E5-2697 v2 @ 2.7 GHz (2 processors) 48 cors RAM 256 GB

Is any reporting level configuration is required how to boost-up the drill-dwon report performance.

Please help us.

Thanks in advance!

Chandan A