I am checking functionality of pooling by running 2 consecutive tests: open connection close connection - repeated x1000 DBCP proves to be much faster than with no pooling (as expected). if I add one more step to each test: open connection connection.isClosed() close connection the timings change massively - DBCP now takes longer than without pooling.
I would expect times for each test to increase by the same amount, since the underlying connection object should be handling the con.isClosed call, and DelegatingConnection seems to pass request straight on. This change in response times only seems signification when testing against MS SQL. Is there a simple explanation for this ? thanks Andy -----Original Message----- From: Morgan Delagrange [mailto:[EMAIL PROTECTED]] Sent: 16 January 2002 21:39 To: Jakarta Commons Developers List; [EMAIL PROTECTED] Subject: Re: Jdbc2pool 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" <[EMAIL PROTECTED]> To: "Jakarta Commons Developers List" <[EMAIL PROTECTED]> 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:[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]> _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
