#1 2015-11-04 15:24:47

georgeCh
Member
Registered: 2014-11-12

Perfomance is very slow on Birt Reports

We face a masive difference in excecution times when trying to excecute a report on the same machine through Eclipse and ReportServer.
Eclipse produces a 30 page report in 3-5 seconds while Report Server needs for the same 30 page report 1 minute and 30 seconds.

Setup is windows server Xeon 1.6, 8GB RAM, postgres 9.4
Tomcat is configured as per below:
-Dfile.encoding=UTF8
-Xms1024m
-Xmx4056m
-XX:PermSize=512m
-XX:MaxPermSize=4056m
-XX:SurvivorRatio=6

Can you please advice if there are any configurations to be made in order to minimize the time?

Offline

#2 2015-11-04 15:31:46

Arno Mittelbach
datenwerke
Registered: 2012-02-14

Re: Perfomance is very slow on Birt Reports

Hi,

that sounds a bit odd. The first time after a fresh start of ReportServer BIRT reports are slower since the Birt Report Engine needs to be started up. But even that should not cause such a huge discrepancy. Is there anything special about the report that you can see? Is this something that happens only with that one particular report, or are you experiencing a time discrepancy with all BIRT reports?

Cheers
-Arno

Offline

#3 2015-11-04 15:55:25

georgeCh
Member
Registered: 2014-11-12

Re: Perfomance is very slow on Birt Reports

The report mentioned has parameters but I doubt that might be the issue. Unfortunately problem is not on a single report for example I have tried a 51 page report (that takes no parameters) through eclipse it needs 6 seconds through ReportServer 1:20.

Thanks for the quick response,
George

Offline

#4 2015-11-04 16:00:44

Arno Mittelbach
datenwerke
Registered: 2012-02-14

Re: Perfomance is very slow on Birt Reports

What version of BIRT are you using when running the reports through eclipse?

Cheers
-Arno

Offline

#5 2015-11-04 16:04:08

georgeCh
Member
Registered: 2014-11-12

Re: Perfomance is very slow on Birt Reports

rptdesign Xml includes the following...

<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.23" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 4.5.0.v201506092134 Build &lt;@BUILD@></property>


George

Offline

#6 2015-11-04 16:14:38

georgeCh
Member
Registered: 2014-11-12

Re: Perfomance is very slow on Birt Reports

Also something we have noticed is that the progress bar does not show any progress for most of the time and goes from 0 to 100% within 1-2 seconds at the end.

Offline

#7 2015-11-05 09:59:18

Arno Mittelbach
datenwerke
Registered: 2012-02-14

Re: Perfomance is very slow on Birt Reports

Hi George,

the progress bar is expected behavior. The progress bar only "measures" the time it takes to load the PDF but not the time it actually takes to create the PDF. As for the performance problem, I've filed a ticket to investigate this under [RS-1958]. It would be helpful if it was possible for you to send us the problematic .rptdesign file (preferably the one without parameters). Feel free to contact us at info@datenwerke.net.

Sorry that I cannot be of more help for now. In case this is a pressing issue, you might also consider dropping our support team an email (see https://reportserver.net/en/services/ for further infos).

Kind regards
Arno

Offline

Board footer

Powered by FluxBB