Very very large reports

[jackdawson]

Hello all,
    I looked at most of the other threads in this forum for finding a solution to generate a very very large report smoothly.
    My report has 3 subreports in it and when run for a single day produces around 25,000 pages. I hate to say this but there's
    a plan that this report would be run for 6 month period or even for larger periods.
   
    Can anyone let me what are the chances for this being possible?
   
    I don't think I could even save the JasperPrint object in the database as CLOB because I won't get it until it is complete and filled up.
    And, before it completes it's obvious for an 'Out of Memory' guy to show up.
   
    Thanks in advance.

 

Post Edited by Jack Dawson at 03/18/09 17:19

[jackdawson]

JRGzipVirtualizer worked great for a 1day report(around 25,000 pages). It was fast too. I'm not sure if it works for bigger date ranges.

Everything (I mean all the procedures for generating large reports) converges at 'increase memory' step.

[jackdawson]

One thing which puzzles me is - when a 1 day's report is generated the size of it is around 30MB.
So, when I run for 2 days it should be around 60MB. I increased the JVM size from 760M to 1024M and that's the highest I could go.I'm sure JVM has enough heap space to accommodate the second one too. Then, why is it throwing Out of memory error?

 

 

 

Post Edited by Jack Dawson at 03/20/09 19:57

[pioppogatto]

Hallo,

how can you increase th JVM memory?

Thank you