nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Birt peformance issue

Arif shah

Hi, I have created few very simple dashboards. The data is coming from an excel and the amount of data is low and expressions are also not complex If I run the dashboard in preview, the dashboard runs in a couple of seconds or even less than that..sometimes in one second However, If I run the same dashboard on apache tomcat/birtviewer, the dashboard takes from 20 seconds to five minutes...everytimes takes different amount of time Can someone please suggest what steps can I take to debug and resolve this performance issue Arif

Find more posts tagged with

Comments

GLO_FR

Hi, What version of BIRT are you using ? Are you talking about the BIRT dashboard (=commercial version) or about a report which looks like a dashboard ?

Arif shah

I am talking about Birt OS. I have a couple of Bar charts based on some excel data. The issue is that even on tomcat it takes variable time..some times 10 seconds and sometimes even a minute to run. The same report never took more than five seconds on report designer preview Arif

GLO_FR

Hi, Did you try to increase the memory size on the tomcat server ?

Arif shah

I haven't tried to increase the memory on the server. However, on my development machine which has 6 gb machine, I tried to install the tomcat and birtviewer.On my laptop and birt designer, the report runs in few seconds in preview, but on tomcat localhost/report viewer, it takes 10 - 20 seconds. The response on my laptop localhost/birtviewer is still much better than the response on the server tomcat/birtviewer. However, even then 10-20 seconds execution time is too long as the dashboards are really simple. The Birt designer shows that the report itself runs in a second or two. It means that the long response time has something to do with tomcat/birtviewer Could it be that my machine has better specs than the server and for the report to run on tomcat/birtviewer, we need better memory and CPU resources? Syed

GLO_FR

<blockquote class="ipsBlockquote" data-author="Arif shah" data-cid="128793" data-time="1403513137"><div> Could it be that my machine has better specs than the server and for the report to run on tomcat/birtviewer, we need better memory and CPU resources? </div></blockquote> Maybe. By default BIRT OS has 256mb memory (eclipse.ini file)On the server (the one on your laptop), first try to set the same default memory alocation and make some runs. But as you said, the performance problem seems to be on server side.If you want/can, upload an example, I'll try on my side

micajblock

Try using a real database. Excel is not a multi-threaded data source. P.S. Commercial BIRT has these features OOTB.