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:[EMAIL PROTECTED]] Sent: 16 January 2002 18:57 To: Jakarta Commons Developers List; [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> __________________________________________________ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>