If it's the freeTDS driver you're using, I believe that it has built-in pooling capabilities. That might explain why you don't get any benefit from using another pool on top of that.
/Dennis Andy Olliver wrote: > 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]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>