[Connector] Stress tests

["Hamilton Verissimo de Oliveira (Engenharia - SPO)" <ha...@agenciaclick.com.br>]

Hi there,

Has anyone made some stress tests on connection pool's implementation under
Connector? I know its code, and I don't think I've seen bottlenecks, but
people from the QA team here raised this issue. 

My environment:

- Oracle database
- Pool with 20 connection at maximum
- Through JMeter, 50 threads requesting some page.

I am working on it saturday, but I'd like to have some feelings about it.


Cheers,
hammett

Re: [Connector] Stress tests

[David Jencks <da...@coredevelopers.net>]

I started on some tests but didn't come to any conclusions.

You might want to check that the application code is closing 
connections and ending transactions promptly.

I'm not sure what adapter you are using, or if Oracle actually supplies 
an adapter themselves (there appear to be some adapter classes in the 
10g jar).  You might consider using the tranql Oracle adapter and using 
Oracle internal datasource pooling instead of Geronimo pooling.  We 
haven't actually tried this significantly yet, so if you try it please 
let us know how it works.

The tranql adapter:

cvs.openejb.org:/home/projects/tranql/scm

You need both the connector and vendor cvs modules.

You also need the maven rar plugin which is released by maven but not 
yet in a distro.  I'm not sure if it is downloaded automatically or if 
you need to install it by

maven plugin:download -DartifactId=maven-rar-plugin -DgroupId=maven 
-Dversion=1.0

I'm quite interested in whatever you come up with.

Thanks
david jencks

On Thursday, June 24, 2004, at 12:40 PM, Hamilton Verissimo de Oliveira 
(Engenharia - SPO) wrote:

>
> Hi there,
>
> Has anyone made some stress tests on connection pool's implementation 
> under
> Connector? I know its code, and I don't think I've seen bottlenecks, 
> but
> people from the QA team here raised this issue.
>
> My environment:
>
> - Oracle database
> - Pool with 20 connection at maximum
> - Through JMeter, 50 threads requesting some page.
>
> I am working on it saturday, but I'd like to have some feelings about 
> it.
>
>
> Cheers,
> hammett
>