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,
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