BIRT Report with Large Data Set

Hi, 
I am using Eclipse BIRT 3.7 version for developing web application.It requires to display read only data. 
Here My requirements are to display the list of transactions with pagination and Column sorting features. 
I have designed the Report and used <birt:viewer tag to display the report as page in web application. 
 
This works well with small data sets.But If I work with Large data sets like more than 10000 rows, it is taking lot of time to display the report in page. This is just an example.But in production, it will be 1000000 records might be there. 
So here what I have observed is it is loading all the data as rptdocument type in the disk and displaying the data based on that. 
Can you please help me to achieve the pagination feature with Large data sets and should get only 10 or 20 records for the first time. 
 
Thanks 
Vinod

Find more posts tagged with

Comments

JasonW

Vinod,

How long is it taking to display the first page? How long does the actual query take to run?

Jason

vinodevs

Hi Jason,
To display the first page, it is taking approximately around 3 to 4 minutes for 10000 rows And the actual query is taking less time to execute in the database.
What I have observed while working with around 100 rows is, BIRT is loading all 100 records into rptdocument and then start displaying data with pagination.
BIRT is taking time to prepare/write the rptdocument to the file system.I have observed the same behaviour with column sorting also.
So for every database call, it is created rptdocument type in temporary directory or working directory.

Please help me to sort out this issue.

Thanks
Vinod

JasonW

Vinod,

It may be best to open a bugzilla entry so the devs can look at your design.

Jason