Eclipse Community Forums: BIRT » How to write RPTDOC file in chunk

Help

Home

Home » Archived » BIRT » How to write RPTDOC file in chunk

Show: Today's Messages :: Show Polls :: Message Navigator

How to write RPTDOC file in chunk [message #1612975]

Thu, 12 February 2015 10:18

Eclipse User

Messages: 10
Registered: May 2014

Junior Member

We are using Eclipse Birt 4.3.2.
We use ScriptedDataSetEventAdapter and fire the database query in Java code to retrieve the data. Data retrived from database is very large. It creates nearly 400 MB report data file(birt intermidiate file) on file system. It keeps 400 MB of data in memory.

Is there any way in BIRT to write the report data file(birt intermidiate file) in chunk so that we do not have to keep 400 MB data in memory..

For example: Consider i have 1,00,000 rows in my report. Instead of fetching all the rows from database, we are planning to use pagination and fetch 10000 rows from database at a time and write it to birt intermediate file.

Once 10000 rows are written birt intermediate file. We will make another query to fetch the next 10000 rows and write it to report data file(birt intermidiate file).

Is this possible?
By this we do not have to keep large amount of data in memory.

Report message to a moderator