Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Scalability problems with BIRT
Scalability problems with BIRT [message #361312] Mon, 24 March 2008 03:44 Go to next message
Dinesh Varadharajan is currently offline Dinesh VaradharajanFriend
Messages: 6
Registered: July 2009
Junior Member
We are doing load testing for an which also contains BIRT reports(BIRT 2.2).
It scales well for 100 users. But when we increase the load to 200 users
only the birt reports are not scaling. The queries are scaling fine. The
ajax request time keeps on increasing from 200ms to 40sec. Is there any
known issue which we are aware of in this particular release. CPU and
memory are not clogging.

Is there any specific JVM argument which we need to set or some patch we
need to apply. Any help is much appreciated.

Dinesh
Re: Scalability problems with BIRT [message #361319 is a reply to message #361312] Mon, 24 March 2008 14:10 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: jasonweathersby.alltel.net

Dinesh,

Can you log a bugzilla entry for this?

Jason

Dinesh Varadharajan wrote:
> We are doing load testing for an which also contains BIRT reports(BIRT 2.2).
> It scales well for 100 users. But when we increase the load to 200 users
> only the birt reports are not scaling. The queries are scaling fine. The
> ajax request time keeps on increasing from 200ms to 40sec. Is there any
> known issue which we are aware of in this particular release. CPU and
> memory are not clogging.
>
> Is there any specific JVM argument which we need to set or some patch we
> need to apply. Any help is much appreciated.
>
> Dinesh
>
>
Re: Scalability problems with BIRT [message #361343 is a reply to message #361319] Tue, 25 March 2008 13:29 Go to previous messageGo to next message
Dinesh Varadharajan is currently offline Dinesh VaradharajanFriend
Messages: 6
Registered: July 2009
Junior Member
Hi Jason,
Surely I will. But before that I want to ascertain it as a bug. To give more
information, I downloaded the latest birt2.2 runtime and tested the sample
test.rptdesign(bundled along with birt) for 200 users in tomcat.(have enough
memory and threads). Still it is not scaling.(ajax request takes upto
20sec).

I am sure lot of people are using birt in production systems. And whatever I
am doing is nothing complex. I want to be sure that there is nothing missing
from my side before posting it as a bug in BIRT.

Dinesh
"Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
news:fs8che$9bv$1@build.eclipse.org...
> Dinesh,
>
> Can you log a bugzilla entry for this?
>
> Jason
>
> Dinesh Varadharajan wrote:
>> We are doing load testing for an which also contains BIRT reports(BIRT
>> 2.2). It scales well for 100 users. But when we increase the load to 200
>> users only the birt reports are not scaling. The queries are scaling
>> fine. The ajax request time keeps on increasing from 200ms to 40sec. Is
>> there any known issue which we are aware of in this particular release.
>> CPU and memory are not clogging.
>>
>> Is there any specific JVM argument which we need to set or some patch we
>> need to apply. Any help is much appreciated.
>>
>> Dinesh
>>
Re: Scalability problems with BIRT [message #361357 is a reply to message #361343] Wed, 26 March 2008 05:33 Go to previous messageGo to next message
alex is currently offline alexFriend
Messages: 15
Registered: July 2009
Junior Member
Hi Dinesh:
which database you used,oracle? the database have a max connection process parameter.for example to oracle,you can use follow sql in sqlplus :
select count(*) from v$session where TYPE = 'USER'
if the value is lower than 200,you need to increase the value according to the database document.
when you want to do the load testing.you can log to database seperately and execute some very small and simple sql many times.If the speech is very slow in sometimes not
alltimes,maybe it's database connection problem too.
if this is not database connection problem,then do you use any java connection pooling framework such as c3p0 or others and what's the max connection parameter you use?
if the problem still didn't solved.you can seperate the database and application.you can use any application for example a php application connected to your current database
and do the load testing , then use your birt application connect to other database such as mysql or just the demonstrate sample derby embed classicmodels database.

Thanks
Alex

Dinesh Varadharajan wrote:
> Hi Jason,
> Surely I will. But before that I want to ascertain it as a bug. To give more
> information, I downloaded the latest birt2.2 runtime and tested the sample
> test.rptdesign(bundled along with birt) for 200 users in tomcat.(have enough
> memory and threads). Still it is not scaling.(ajax request takes upto
> 20sec).
>
> I am sure lot of people are using birt in production systems. And whatever I
> am doing is nothing complex. I want to be sure that there is nothing missing
> from my side before posting it as a bug in BIRT.
>
> Dinesh
> "Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
> news:fs8che$9bv$1@build.eclipse.org...
>> Dinesh,
>>
>> Can you log a bugzilla entry for this?
>>
>> Jason
>>
>> Dinesh Varadharajan wrote:
>>> We are doing load testing for an which also contains BIRT reports(BIRT
>>> 2.2). It scales well for 100 users. But when we increase the load to 200
>>> users only the birt reports are not scaling. The queries are scaling
>>> fine. The ajax request time keeps on increasing from 200ms to 40sec. Is
>>> there any known issue which we are aware of in this particular release.
>>> CPU and memory are not clogging.
>>>
>>> Is there any specific JVM argument which we need to set or some patch we
>>> need to apply. Any help is much appreciated.
>>>
>>> Dinesh
>>>
>
Re: Scalability problems with BIRT [message #361360 is a reply to message #361357] Wed, 26 March 2008 09:58 Go to previous message
Dinesh Varadharajan is currently offline Dinesh VaradharajanFriend
Messages: 6
Registered: July 2009
Junior Member
Hi Alex,
Thanks for the inputs. I have executed the report which doesn't have any
datasource. I tested the default test.rptdesign that comes along with birt
runtime.war.

In my original test case, I made sure the database is not clogging. We have
installed monitoring/profiling tools in db as well as the application
server. That doesnt sound as a problem in our case.

Thanks,
Dinesh
"Alex" <jj12tt@yahoo.com.cn> wrote in message
news:fscn76$vqm$1@build.eclipse.org...
> Hi Dinesh:
> which database you used,oracle? the database have a max connection
> process parameter.for example to oracle,you can use follow sql in sqlplus
> :
> select count(*) from v$session where TYPE = 'USER'
> if the value is lower than 200,you need to increase the value according to
> the database document.
> when you want to do the load testing.you can log to database seperately
> and execute some very small and simple sql many times.If the speech is
> very slow in sometimes not alltimes,maybe it's database connection problem
> too.
> if this is not database connection problem,then do you use any java
> connection pooling framework such as c3p0 or others and what's the max
> connection parameter you use?
> if the problem still didn't solved.you can seperate the database and
> application.you can use any application for example a php application
> connected to your current database and do the load testing , then use your
> birt application connect to other database such as mysql or just the
> demonstrate sample derby embed classicmodels database.
>
> Thanks
> Alex
>
> Dinesh Varadharajan wrote:
>> Hi Jason,
>> Surely I will. But before that I want to ascertain it as a bug. To give
>> more information, I downloaded the latest birt2.2 runtime and tested the
>> sample test.rptdesign(bundled along with birt) for 200 users in
>> tomcat.(have enough memory and threads). Still it is not scaling.(ajax
>> request takes upto 20sec).
>>
>> I am sure lot of people are using birt in production systems. And
>> whatever I am doing is nothing complex. I want to be sure that there is
>> nothing missing from my side before posting it as a bug in BIRT.
>>
>> Dinesh
>> "Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
>> news:fs8che$9bv$1@build.eclipse.org...
>>> Dinesh,
>>>
>>> Can you log a bugzilla entry for this?
>>>
>>> Jason
>>>
>>> Dinesh Varadharajan wrote:
>>>> We are doing load testing for an which also contains BIRT reports(BIRT
>>>> 2.2). It scales well for 100 users. But when we increase the load to
>>>> 200 users only the birt reports are not scaling. The queries are
>>>> scaling fine. The ajax request time keeps on increasing from 200ms to
>>>> 40sec. Is there any known issue which we are aware of in this
>>>> particular release. CPU and memory are not clogging.
>>>>
>>>> Is there any specific JVM argument which we need to set or some patch
>>>> we need to apply. Any help is much appreciated.
>>>>
>>>> Dinesh
>>>>
>>
Previous Topic:Birt Viewer plugin for Firefox?
Next Topic:unable to view report as Doc
Goto Forum:
  


Current Time: Sat Dec 20 23:03:45 GMT 2014

Powered by FUDForum. Page generated in 0.01642 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software