Skip to main content



      Home
Home » Archived » BIRT » BIRT Large Dataset Performance(Performance goes down with large datsets)
BIRT Large Dataset Performance [message #1095908] Tue, 27 August 2013 13:54 Go to next message
Eclipse UserFriend
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 #1096491 is a reply to message #1095908] Wed, 28 August 2013 09:13 Go to previous messageGo to next message
Eclipse UserFriend
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.
Re: BIRT Large Dataset Performance [message #1098226 is a reply to message #1096491] Fri, 30 August 2013 16:18 Go to previous messageGo to next message
Eclipse UserFriend
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 16:25] by Moderator

Re: BIRT Large Dataset Performance [message #1101073 is a reply to message #1098226] Tue, 03 September 2013 21:23 Go to previous messageGo to next message
Eclipse UserFriend
Sorry for the delay. You can send it to mwilliams.actuate at gmail.
Re: BIRT Large Dataset Performance [message #1103892 is a reply to message #1101073] Sat, 07 September 2013 09:50 Go to previous messageGo to next message
Eclipse UserFriend
Thanks Michael, you should have it now.
Re: BIRT Large Dataset Performance [message #1106222 is a reply to message #1103892] Tue, 10 September 2013 17:12 Go to previous messageGo to next message
Eclipse UserFriend
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.
Re: BIRT Large Dataset Performance [message #1111242 is a reply to message #1106222] Tue, 17 September 2013 21:11 Go to previous messageGo to next message
Eclipse UserFriend
Thanks Michael, I was not checking work for a few days... am back now and tried after removing the nested/embedded table. It does give some improvement but not to the extent of considerable notice.
With these embedded tables the report runs for ~8 to 10 hrs and once I remove these it still goes on for ~6 hrs. Do you think there is something else I should be looking for. I have a hunch, every cell contains "if" statements, does that matter ?
Re: BIRT Large Dataset Performance [message #1111243 is a reply to message #1111242] Tue, 17 September 2013 21:15 Go to previous messageGo to next message
Eclipse UserFriend
Another thing, going back to what you suggested, I will try that now but need one help - how do I link these 2 datasets using parameter ? I can define a new parameter but linking 2 dataset is something new for me.. help please !!
Re: BIRT Large Dataset Performance [message #1111796 is a reply to message #1111243] Wed, 18 September 2013 14:58 Go to previous message
Eclipse UserFriend
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.
Previous Topic:creating new table rows in script
Next Topic:Does BIRT 2.6.1 support IE 9
Goto Forum:
  


Current Time: Thu Jul 24 00:10:07 EDT 2025

Powered by FUDForum. Page generated in 0.07695 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top