Will the jasper able to generate pdf file with 50 million records which is present in the data base

Hi Team,

My data base table has around 50 million records in data base table. will the jasper really handle these many records to present them in pdf without facing any OutOfMemoryError.

When we are running jasper report we are getting the out of memory error.

Please provide us some best approch to generate the report

Thanks & Regards,

venkateshm's picture
Joined: Apr 19 2011 - 1:22am
Last seen: 8 years 3 months ago

3 Answers:

I would recommend pushing all the calculations to the database with group by and aggregation functions - don't try to bring that much data "in memory" - also you might look at Infobright as a different MySQL backend to handle large BI queries


ernestoo's picture
Joined: Nov 29 2010 - 11:59am
Last seen: 5 years 4 months ago

Thank you @ernestoo for reply. Could you please explain some more details how to handle this.

venkateshm - 8 years 3 months ago

I just mean that you shouldn't do select * from table and then try to use Jaspersoft variables to do count, sum, avg, etc...you should do it in the database like select sum(field) from table group by something

Regarding Infobright you can read more here https://www.infobright.com/

ernestoo - 8 years 3 months ago

I can't think of any reason to output 50 million records in any format. Ernesto is saying, let the DB Server manage the 50 million records. The JasperReports Server should only be presented the data you actually want to see in your Reports. You do this thru careful consideration of the queries you ask of the DB Server.

djohnson53 - 8 years 3 months ago

First, if there is going to be several users going to view the report, using JasperReports Server may not be the best option.

Also, I would try to break up the report into several reports instead of trying to create a single pdf file.

hozawa's picture
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 7 months ago
sfriedman's picture
Joined: Oct 22 2008 - 3:26am
Last seen: 7 years 9 months ago