|
Re: Scalability problems with BIRT [message #361319 is a reply to message #361312] |
Mon, 24 March 2008 14:10 |
Eclipse User |
|
|
|
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 #361357 is a reply to message #361343] |
Wed, 26 March 2008 05:33 |
alex 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 |
Dinesh Varadharajan 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
>>>>
>>
|
|
|
Powered by
FUDForum. Page generated in 0.04968 seconds