|
Re: BIRT Large Dataset Performance [message #1096491 is a reply to message #1095908] |
Wed, 28 August 2013 13:13 |
|
What version of BIRT are you using? What is your design like? Are you using embedded tables or other elements in your groups? Also, what is your data like? Many columns as well, with long data? Also, what is your dataSet type? If you can attach your report design, maybe I can take a look to see if there is anything I see you could do to speed it up.
Michael
Developer Evangelist, Silanis
|
|
|
Re: BIRT Large Dataset Performance [message #1098226 is a reply to message #1096491] |
Fri, 30 August 2013 20:18 |
Eclipse Beginner Messages: 23 Registered: September 2011 |
Junior Member |
|
|
Hi Michael,
Am using BIRT 4.3 and the design is using oracle as data source. It does have tables and many columns. One thing I checked - with 3.7 (xls) it takes a few minutes but with 4.3 (xlsx) it runs for hours. It has a couple of tables and then embedded table in each of these - each bound to the same dataset.
Regarding the design - is there a way to send it to you direct (would prefer that) or do I have to upload it here only ?
[Updated on: Fri, 30 August 2013 20:25] Report message to a moderator
|
|
|
|
|
Re: BIRT Large Dataset Performance [message #1106222 is a reply to message #1103892] |
Tue, 10 September 2013 21:12 |
|
The thing I see is the embedded table toward the bottom of the report that is bound to the same dataSet as the table it's embedded into. There are no filters or dataSet parameters limiting the returned values. This seems to be somewhere where you'd be running into an issue. You could separate the query for this data to another dataSet and use dataSet parameter binding to pass a value from the outer table to the inner query to only return the needed results.
Michael
Developer Evangelist, Silanis
|
|
|
|
|
Re: BIRT Large Dataset Performance [message #1111796 is a reply to message #1111243] |
Wed, 18 September 2013 18:58 |
|
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.
Michael
Developer Evangelist, Silanis
|
|
|
Powered by
FUDForum. Page generated in 0.04302 seconds