Optimizing data retrieval in BIRT

pawasarmol

Hello Everyone,

I had a question regarding BIRT data retrieval.

As per my understanding , whenever we send a sql query to the BIRT engine, it will process the query, gather the data, render the report and finally perform pagination. This works fine if the data that I am retrieving is relatively small.

But with large amount of data (I have couple millions of records returned by my query right now) performance is a problem. So i am wondering right now if there is a function in BIRT to limit the number of records returned for each page (lets say 100) , and when ever the end of page is reached (100 record have been displayed to the user) , it would retrieve the next set of records (next 100) and so on.

Is this possible with BIRT,or is there a work around ?

Thanks

thuston

No it is not possible. All the data must be collected for aggregations to function. Also, the final page rendering is different for each output format.