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
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,
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
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.
Posted on October 23, 2014 at 5:16am