Jasper Server Virtualizer

0

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

reportdev's picture
1232
Joined: Oct 12 2015 - 12:05pm
Last seen: 2 months 4 weeks ago

0 Answers:

No answers yet
Feedback
randomness