BIRT Large Dataset Performance [message #1095908] |
Tue, 27 August 2013 13:54  |
Eclipse User |
|
|
|
Hi,
I am using BIRT to dump some data down in reports. It works good upto some size of datasets, and as the dataset grows the performance goes down. I have a dataset with ~30K rows that are handed over to BIRT for grouping and displaying. It just seem to take hours and hours to process this, what can I possibly do to improve this ?
|
|
|
|
|
|
|
|
|
|
Re: BIRT Large Dataset Performance [message #1111796 is a reply to message #1111243] |
Wed, 18 September 2013 14:58  |
Eclipse User |
|
|
|
Well, your two tables are made from the same dataSet. If you simply create a query that returns the results you want in the embedded table, you can create a dataSet parameter by using the '?' marker in the query. For example, select * from table where field = ?. Now, if you select the embedded table that is bound to this dataSet and go to the binding tab, you'll see a button for dataset parameter binding. If you select this, you can pass the group value from the outer table to the inner table to limit the inner query results.
|
|
|
Powered by
FUDForum. Page generated in 0.07695 seconds