commons-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andy Olliver" <a...@slyfrog.com>
Subject RE: Jdbc2pool
Date Wed, 16 Jan 2002 21:11:29 GMT
Randy

I must apologise - I have been trying out 2 different pooling
implementations - the 'Ewin Connection Pool', and 'DBCP'.
Ewin always breaks on me when trying to write serialised objects to MS SQL
Server.
DBCP does as it should with all the SQL I use, but shows interesting
characteristics under load with MS SQL - openning and closing 100
connections from the pool is no faster than trying it without the pool. With
MySQL I see a factor of x5 difference. (- data below).

Is there any obvious reason for this that I am missing.
With the Ewin pool I see great speed improvements for the same test, but run
into other problems.

thanks
Andy Olliver

##################
Test: Open and Close connection x 100:

MS SQL
without pool: 1030 ms
with pool: 1005
driver = com.inet.tds.TdsDriver
validation query = null

MySQL
without pool: 880 ms
with pool: 170
driver = org.git.mm.mysql.Driver
validation query = null
similar results also with ODBC bridge.
##################

-----Original Message-----
From: Randy Speh [mailto:rwspeh@yahoo.com]
Sent: 16 January 2002 18:57
To: Jakarta Commons Developers List; andy@slyfrog.com
Subject: Re: Jdbc2pool


Just curious,
What do you mean when you say it doesn't support all
the SQL you are using?

Thanks,
Randy Speh


--- Andy Olliver <andy@slyfrog.com> wrote:
>
> Here are some small changes to the files of
> jakarta-sandbox-jdbc2pool to
> correct the old package name - I can only read from
> CVS, so here is a zip of
> changed files.
>
> I started off using DBCP, but it doesn't seem to
> support all the SQL I am
> using, so perhaps this alternative will help.


> If so I will look to create the necessary factory
> classes to integrate with
> Tomcat 4 (unless someone has done this already..)
>
> I believe all classes in this project should now
> belong to:
> org.apache.commons.jdbc2pool
> not
> org.apache.commons.torque
>
> I am hoping to do some testing on this solution,
> should I be creating a test
> package:
> test.apache.commons.jdbc2pool for any usefull test
> classes?
>
> Andy
>

> ATTACHMENT part 2 application/x-zip-compressed
name=changes.zip
> --
> To unsubscribe, e-mail:
> <mailto:commons-dev-unsubscribe@jakarta.apache.org>
> For additional commands, e-mail:
<mailto:commons-dev-help@jakarta.apache.org>


__________________________________________________
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/

--
To unsubscribe, e-mail:
<mailto:commons-dev-unsubscribe@jakarta.apache.org>
For additional commands, e-mail:
<mailto:commons-dev-help@jakarta.apache.org>


--
To unsubscribe, e-mail:   <mailto:commons-dev-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:commons-dev-help@jakarta.apache.org>


Mime
View raw message