Urgent - Very long processing

In Birt Viewer it takes few hour to display a simple report. We use Birt 2.2.2 2008 plugin for Eclipse, Tomcat 5.25 and Oracle 10g. When I run query from Data set in 10g, it takes 00:00:07.34 sec and return 71461 records.

Boris

Find more posts tagged with

Comments

mwilliams

Hi Boris,

So, when you run the report in just the BIRT designer it takes several hours?

bmil

Yes. But I will try it in batch mode to find out more.
Thanks.

Boris

ps.: sorry for late respond, I'm a web, java, report, .. developer in one.

25. sep. 08

Eclipse is running with following arguments:
C:User Program FilesBRDProeclipse>"C:User Program FilesBRDProeclipseeclipse.exe" -vm "C:User Program Filesjdevstudio10133jdkbinjavaw.exe" -vmargs -Xmx256m -XX:MaxPermSize=128m

In preview of Dataset with default params it takes about 1 min to display data
In web viewer in Eclipse it takes about hour, to display the same data
PC is: Pent 4, 3.2Ghz, 1GB RAM
It takes about an hour rendering a report in Eclipse BIRT web viewer?

If I change eclipse arguments to: -vmargs -Xmx768m -XX:MaxPermSize=512m
,it takes now about 14 min to rendering a report in Eclipse BIRT web viewer. My be Xmx512m and MaxPermsize=256m is OK to.

Boris

bmil

Our configration is xen virtual server with 2GB RAM. Web server is Apache 2.2 and application server is Tomcat 5.5.25 and both are on the same virtual server. An Oracle 10g DB is on remote network. Network is a little bit slow.
Catalina params are: -Xms40m -Xmx512m -XX:MaxPermSize=256m
Birt Web Viewer response is very slow. I run the same report with diferent params, what means different volume of data is returned. It takes few minutes whenles than hundred lines of data are returned. It takes more then ten minutes when some hundreds lines of data are returned. And viewer stoped with no report returned when some thousends lines (>10,000) of data are returned. Log file is created and is empty (ReportEngine_2008_09_25_05_46_28.log).

Thanks

Boris

mwilliams

Boris,<br />
<br />
I'll look into this and see if there's anything that can be done to help lower your processing time. In the time being, here is a link to a presentation posted in the devShare about designing high performance BIRT reports that could possibly help you maximize the efficiency of your report designs.<br />
<br />
<a class='bbc_url' href='http://www.birt-exchange.com/devshare/designing-birt-reports/371-designing-high-performance-birt-reports/'>Designing High Performance BIRT Reports - Other Resources - BIRT Exchange</a>