BIRT report is taking too much time to get generated

hello,
i am trying to execute a birt report which contains 5 or 6 nested groupings. The report is taking too much time to get generated. The sql behind, is taking a couple of seconds. Do you know how can i enhance my report's execution? I am using birt 3.7.2

Regards
Boulos

Find more posts tagged with

Comments

Tubal

How many rows are in your final report?

kclark

You could take a look at <a class='bbc_url' href='http://www.birt-exchange.org/org/devshare/designing-birt-reports/977-webinar-archive-designing-high-performance-birt-reports/'>this devshare</a> it talks about performance tips when designing a BIRT report.

boulos

<blockquote class='ipsBlockquote' data-author="'Tubal'" data-cid="111011" data-time="1351530936" data-date="29 October 2012 - 10:15 AM">
How many rows are in your final report? </blockquote>
 
Hello Tubal, 
 
my sql is returning 7368 rows, but my grouping criteria should generate a report with more than 300 pages. 
 
thanks 
Boulos

Tubal

<blockquote class='ipsBlockquote' data-author="'boulos'" data-cid="111024" data-time="1351591955" data-date="30 October 2012 - 03:12 AM">
Hello Tubal, 
 
my sql is returning 7368 rows, but my grouping criteria should generate a report with more than 300 pages. 
 
thanks 
Boulos </blockquote>
 
I think that's why. BIRT generates the entire report before it shows it. And 300 pages is quite a lot to generate, especially if you are doing any data manipulation in birt or converting it to a document beforehand. 
 
It may not make sense in your case, but one option might be to use drill down reports and break your report up into multiple reports. i.e. the first report will show upper level groups, click on a link to get a report of the subgroup, etc. 
 
Another thing to look at is to make sure that your database is doing all your filtering. SQL will filter a lot faster than BIRT. So you will want BIRT to start with the least amount of data possible. i.e. you mention that your SQL returns 7368 rows. Do you use all 7368 rows in your report (sounds like you do with 300 pages). 
 
I think Actuate's commercial product will start sending the report as soon as the first page is generated.

boulos

<blockquote class='ipsBlockquote' data-author="'Tubal'" data-cid="111028" data-time="1351603996" data-date="30 October 2012 - 06:33 AM">
I think that's why. BIRT generates the entire report before it shows it. And 300 pages is quite a lot to generate, especially if you are doing any data manipulation in birt or converting it to a document beforehand. 
 
It may not make sense in your case, but one option might be to use drill down reports and break your report up into multiple reports. i.e. the first report will show upper level groups, click on a link to get a report of the subgroup, etc. 
 
Another thing to look at is to make sure that your database is doing all your filtering. SQL will filter a lot faster than BIRT. So you will want BIRT to start with the least amount of data possible. i.e. you mention that your SQL returns 7368 rows. Do you use all 7368 rows in your report (sounds like you do with 300 pages). 
 
I think Actuate's commercial product will start sending the report as soon as the first page is generated. </blockquote>
 
Hello Tubal, 
 
thank you for your reply but i am not really convinced with this. 
 
1- i have designed the same report using Actuate eRDPro (version 8) and the same report was generated in 8 seconds while with birt it's taking more than 5 mns 
 
2- i am not using any filtering. all the 7368 rows are needed for my report 
 
can you explain why the same report is taking 8 seconds in erdpro 8 while it is taking more than 5 mns using BIRT? do you know if there is a specific configuration in BIRT that boosts the report generation? 
 
Many thanks and kindest regards, 
Boulos

ahsiang

Hi, ereport viewer has the capability called progressive viewing that will show the first page immediately and it will progressively generate and show the report pages at predefined number of pages, say 50 pages at a time until all 300 pages are out. The open source BIRT will collect the data and generate the full report then only it shows you the report. If you want the same capability as ereport, you can have it in commercial Actuate birt Viewer. It also has feature such as interactive viewer and support for flash and html5 charts.

kclark

<a class='bbc_url' href='http://digiassn.blogspot.com/2007/10/birt-progressive-viewing-during-render.html'>Here's a blog post</a> that shows how to use progressive viewing during render. You might want to take a look at it.