venkateshm Posted October 21, 2014 Share Posted October 21, 2014 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 reportThanks & Regards,Venkatesh.M Link to comment Share on other sites More sharing options...
Solution ernestoo Posted October 21, 2014 Solution Share Posted October 21, 2014 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 Link to comment Share on other sites More sharing options...
venkateshm Posted October 21, 2014 Author Share Posted October 21, 2014 Thank you @ernestoo for reply. Could you please explain some more details how to handle this. Link to comment Share on other sites More sharing options...
ernestoo Posted October 21, 2014 Share Posted October 21, 2014 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/ Link to comment Share on other sites More sharing options...
djohnson53 Posted October 21, 2014 Share Posted October 21, 2014 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. Link to comment Share on other sites More sharing options...
hozawa Posted October 22, 2014 Share Posted October 22, 2014 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. Link to comment Share on other sites More sharing options...
sfriedman Posted October 23, 2014 Share Posted October 23, 2014 Consider using a report virtualizer. See here:http://jasperreports.sourceforge.net/sample.reference/virtualizer/http://community.jaspersoft.com/wiki/comparison-report-virtualizers Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now