I'm currently working on a large report, which needs to generate 6000 pages.
The report works on plsql datasource based on a ORACLE_REF_CURSOR.
After executing the plsql, the ORACLE_REF_CURSOR holds the data in the form of a temp table and the report depends on this temp table.
The pslql executes in 5 minutes and generates the temp table, but the Jasper report on the Server takes enormous amount of time (does not complete filling even after 2 hours).
Tried tweaking heap memory. Current settings are -Xms1024m -Xmx8192m.
and also added the virtulizer options as below
<property name="net.sf.jasperreports.virtualizer.files.delete.on.exit" value="TRUE"/>
<property name="net.sf.jasperreports.virtual.page.element.size" value="-1"/>
Any suggestions in improving the performance of this report would be appreciated..