Posted 02 April 2012 - 09:23 AM
We have a report that is taking a really long time to generate when we start getting above 100,000 records. When profiling the report generation I noticed that it caches the result set to disk and then does sequential reads on the file. I tried setting the DataEngine.MEMORY_BUFFER_SIZE to 900MB so it would hold the whole result set in memory and not cache to disk. Yet I still see the file being created and calls to ResultObjectUtil.readData(). For one particular report it made around 900 calls to that method.
Is there a way to speed up the generation of reports? We have creating PDF reports. I have searched Google and the forum and haven't really found any information regarding this. Just posts on how to get BIRT to use less memory. I have attached a graph which shows how the increase in records is impacting the increase in report generation time.
Let me know if there is anything else that I can provide to get better feedback such as the report design, etc.