commons-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Morgan Delagrange" <mdela...@yahoo.com>
Subject Re: Jdbc2pool
Date Wed, 16 Jan 2002 21:39:26 GMT
That's interesting.  Are you working on timings for the jdbc2pool?  If it
gives you good timings for MS SQL, that might indicate a significant
difference between the two.  Or you may just be having difficulties getting
an optimal configuration for DBCP; it still suffers from a high learning
curve with regard to setup.

----- Original Message -----
From: "Andy Olliver" <andy@slyfrog.com>
To: "Jakarta Commons Developers List" <commons-dev@jakarta.apache.org>
Sent: Wednesday, January 16, 2002 3:11 PM
Subject: RE: Jdbc2pool


> 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>


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


--
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