Performance issues in BIRT

Ashwind · 2010-03-02T13:34:07+00:00

Hi , BIRT is taking too long to run big reports. Its taking more than 3 minutes to run 50 page report. Is it usual or do I have to look into any specific issues. I reviewed my sql and it is taking around 10 sec to return the results. What could be the potential causes ?? Any Idea would be…

Ashwind

Hi ,

BIRT is taking too long to run big reports. Its taking more than 3 minutes to run 50 page report. Is it usual or do I have to look into any specific issues.
I reviewed my sql and it is taking around 10 sec to return the results.
What could be the potential causes ??

Any Idea would be great.

Find more posts tagged with

Comments

johnw

Without seeing the report there is no telling.

When benchmarking BIRT reports, you don't want to look at "pages per second" and that is not a true benchmark. You need to look at the number of report elements per second that the BIRT engine can generate on that machine. That is a more appropriate benchmark.

Lots of things can cause performance bottlenecks. The most important is what is the output format. PDF and Doc formats will take longer than HTML. If you are using PDF, what are the fonts you are using.

In terms of report design, how is the report being generated. Is it using Filters, which take longer than using parameters on a dataset? Is the data sets being used in multiple places in the report? Are there sub queries? Have you added in any debug statements to determine which areas of the report have the bottlenecks?

SailRCG

Hi, to re-state what John said... it requires an example of the report design to make a true assesment. But, waiting minutes for 50 pages seems like a long time... I have a report with 4,000 plus pages (not too many unique elements) , and it runs in less than 10 mins. (a time frame which causes me to schedule the report for execution off-hours, until i find a way to run it faster).