Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » BIRT Servlet Stress Test Problem
BIRT Servlet Stress Test Problem [message #531248] Tue, 04 May 2010 10:23 Go to next message
Melvin Mah is currently offline Melvin MahFriend
Messages: 24
Registered: July 2009
Junior Member
I am currently performing a stress test to see how much the BIRT report servlet can take by launching 5-10 reports simultaneously. At around this time, the machine hosting the servlet gets slower and slower particularly if a SQL query used in one of the reports returns a lot of data queried from the database.

From what I've look around and from what other people say about this and some say that it's due to the perm / heap size defined in Weblogic, while some said that it's that maybe the DB connection for the report is not closed.

Two things that I hope to get some answers:

1. Does the close method in IRunAndRenderTask also closes the DB connection to once the query returns its results?

2. Is this whole thing actually got to do with how much PermSize / Heap size that is defined in the Weblogic service?

Re: BIRT Servlet Stress Test Problem [message #531419 is a reply to message #531248] Tue, 04 May 2010 19:52 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Can you set the max perm size on WS to at least 256 and run the test
again? The connection should be getting closed.

-XX:MaxPermSize=256M

Jason

On 5/4/2010 6:23 AM, Melvin Mah wrote:
> I am currently performing a stress test to see how much the BIRT report
> servlet can take by launching 5-10 reports simultaneously. At around
> this time, the machine hosting the servlet gets slower and slower
> particularly if a SQL query used in one of the reports returns a lot of
> data queried from the database.
>
> From what I've look around and from what other people say about this
> and some say that it's due to the perm / heap size defined in Weblogic,
> while some said that it's that maybe the DB connection for the report is
> not closed.
>
> Two things that I hope to get some answers:
>
> 1. Does the close method in IRunAndRenderTask also closes the DB
> connection to once the query returns its results?
>
> 2. Is this whole thing actually got to do with how much PermSize / Heap
> size that is defined in the Weblogic service?
>
>
Re: BIRT Servlet Stress Test Problem [message #531449 is a reply to message #531419] Wed, 05 May 2010 02:24 Go to previous messageGo to next message
Melvin Mah is currently offline Melvin MahFriend
Messages: 24
Registered: July 2009
Junior Member
Hi Jason,

The machine that we're testing has the MaxPermSize set to 512 since the RAM's capacity is 2GB. But if it's a 512, will it still be that slow? If I try to set it to 1024, the service will not start at all.

I'm confused but sorry to ask again whether if IRunAndRenderTask .close() also closes the DB connection once the report rendering process has already finished?

Thanks
Re: BIRT Servlet Stress Test Problem [message #531690 is a reply to message #531449] Wed, 05 May 2010 19:00 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Melvin,

If the connection is a jdbc connection and not setup with JNDI it should
be getting closed. Can you open bug to diagnose the issue?

Jason

On 5/4/2010 10:24 PM, Melvin Mah wrote:
> Hi Jason,
>
> The machine that we're testing has the MaxPermSize set to 512 since the
> RAM's capacity is 2GB. But if it's a 512, will it still be that slow? If
> I try to set it to 1024, the service will not start at all.
>
> I'm confused but sorry to ask again whether if IRunAndRenderTask
> .close() also closes the DB connection once the report rendering process
> has already finished?
>
> Thanks
Re: BIRT Servlet Stress Test Problem [message #531761 is a reply to message #531690] Thu, 06 May 2010 05:15 Go to previous message
Melvin Mah is currently offline Melvin MahFriend
Messages: 24
Registered: July 2009
Junior Member
Jason,

It seems that there is a earlier posting dated 11 August 2008 that I believe fits the problem description:

Link is here.

I believe that the database connection is not closed immediately but only after 30-60 seconds rendering has finished.

I am not sure whether if BIRT 2.5.2 solves the problem or not. The server where I am encountering this uses 2.5.2.

Will be filing an bug issue later.

Thanks.
Previous Topic:How to get a column value in a row in an hadler of type DataItemEventAdapter
Next Topic:how to access dynamically defined data-set columns
Goto Forum:
  


Current Time: Thu Apr 25 07:03:22 GMT 2024

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

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

Back to the top