Will the jasper able to generate pdf file with 50 million records which is present in the data base
Posted on October 21, 2014 at 2:31am
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,
Venkatesh.M
Joined: Apr 19 2011 - 1:22am
Last seen: 8 years 3 months ago
Posted on October 21, 2014 at 3:56am
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
Joined: Nov 29 2010 - 11:59am
Last seen: 5 years 4 months ago
Posted on October 21, 2014 at 9:30pm
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.
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 7 months ago
Posted on October 23, 2014 at 5:16am
Joined: Oct 22 2008 - 3:26am
Last seen: 7 years 9 months ago
Thank you @ernestoo for reply. Could you please explain some more details how to handle this.
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/
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.