Hi, Try minIdle = 19, maxIdle = 20, maxActive = 20, initialSize = 20. I think the maxActive 0 effectively means no pooling.
Yoav Shapira Millennium Research Informatics >-----Original Message----- >From: Henrik Rathje [mailto:[EMAIL PROTECTED] >Sent: Friday, September 10, 2004 12:20 PM >To: Tomcat Users List >Subject: Re: DBCP Performance? > >Hi, >seems you are rite: > >org.apache.commons.dbcp.BasicDataSource source = >(org.apache.commons.dbcp.BasicDataSource)ds; > System.out.println("num of idle connections " + source.getNumIdle() >); > System.out.println("num of max act connections " + >source.getMaxActive() ); > System.out.println("username " + source.getUsername() ); > >prints: >num of idle connections 0 >num of max act connections 0 >username tomcat > >but why? here is the connection pool configuration: ><Resource name="jdbc/sdb-login" auth="Container" > type="javax.sql.DataSource"/> > > <ResourceParams name="jdbc/sdb-login"> > <parameter> > <name>factory</name> > <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> > </parameter> > <parameter> > <name>driverClassName</name> > <value>ca.edbc.jdbc.EdbcDriver</value> > </parameter> > <parameter> > <name>poolPreparedStatements</name> > <value>true</value> > </parameter> > <parameter> > <name>defaultAutoCommit</name> > <value>false</value> > </parameter> > <parameter> > <name>url</name> > <value>jdbc:edbc://localhost:IJ7/sdb</value> > </parameter> > <parameter> > <name>username</name> > <value>tomcat</value> > </parameter> > <parameter> > <name>password</name> > <value>passwd ;-)</value> > </parameter> > <parameter> > <name>initialSize</name> > <value>20</value> > </parameter> > <parameter> > <name>maxActive</name> > <value>0</value> > </parameter> > <parameter> > <name>maxIdle</name> > <value>0</value> > </parameter> > <parameter> > <name>minIdle</name> > <value>20</value> > </parameter> > <parameter> > <name>maxWait</name> > <value>-1</value> > </parameter> > <parameter> > <name>testOnBorrow</name> > <value>false</value> > </parameter> > </ResourceParams> > >Thanks for support, Henrik > > > >On Fri, 10 Sep 2004 11:51:05 -0400 >"Shapira, Yoav" <[EMAIL PROTECTED]> wrote: > >> >> Hi, >> Hmm, with minIdle set to 20 and assuming your test gets one connection >> at a time (or less than 20 at a time), I'm a bit confused. >> >> One next step would be to really verify that the pool has available >> connections before the get connection call. You obviously wouldn't do >> this in a production application, but this is just for debugging a >> performance test. Cast the DataSource to the concrete implementation >> type, probably org.apache.commons.dbcp.BasicDataSource, and call >> getNumIdle on it to verify it's a positive number before calling >> getConnection. If it's zero or negative your pool is misconfigured and >> you're creating a new connection, hence the slow performance. >> >> Yoav Shapira >> Millennium Research Informatics >> >> >> >-----Original Message----- >> >From: Henrik Rathje [mailto:[EMAIL PROTECTED] >> >Sent: Friday, September 10, 2004 11:46 AM >> >To: Tomcat Users List >> >Subject: Re: DBCP Performance? >> > >> >Hi, >> >The minIdle value during this test was: >> ><parameter> >> > <name>minIdle</name> >> > <value>20</value> >> ></parameter> >> >any other suggestions? >> >Thanks in advance, Henrik >> > >> > >> > >> >On Fri, 10 Sep 2004 11:21:08 -0400 >> >"Shapira, Yoav" <[EMAIL PROTECTED]> wrote: >> > >> >> >> >> Hi, >> >> The initial connections can be closed if idle, depending on your pool >> >> configuration, so you might be creating new connections each time >> even >> >> with the pool. Check your minIdle setting. >> >> >> >> If you're creating a new connection each time, a tiny bit of overhead >> >> can be expected for a pool over a direct DriverManager call. But >> that >> >> defeats the purpose of pooling. If your pool is properly configured >> and >> >> has a connection waiting, it should be a little bit more than a hash >> >> lookup to return the connection, which would be significantly faster >> >> than creating a new one. >> >> >> >> Yoav Shapira >> >> Millennium Research Informatics >> >> >> >> >> >> >-----Original Message----- >> >> >From: Henrik Rathje [mailto:[EMAIL PROTECTED] >> >> >Sent: Friday, September 10, 2004 11:16 AM >> >> >To: [EMAIL PROTECTED] >> >> >Subject: DBCP Performance? >> >> > >> >> >Hi, >> >> >has enyone of you recently measured the performance of the DBCP >> >> >Connection Pool? I compared >> >> > >> >> ><snip> >> >> >long start = System.currentTimeMillis(); >> >> >Class.forName("ca.edbc.jdbc.EdbcDriver"); >> >> >Connection dbcon = DriverManager.getConnection(loginUrl, loginUser, >> >> >loginPa$ >> >> >long diff = System.currentTimeMillis() - start; >> >> >System.out.println("creating connection without pool took: " + diff >> + " >> >> >mil$ >> >> ></snip> >> >> > >> >> >with >> >> > >> >> ><snip> >> >> >long start = System.currentTimeMillis(); >> >> >Connection dbcon = ds.getConnection( ); >> >> >long diff = System.currentTimeMillis() - start; >> >> >System.out.println("creating connection with pool took: " + diff + " >> >> >milise$ >> >> ></snip> >> >> > >> >> >And got surprisingly results like this: >> >> > >> >> >creating connection without pool took: 465 miliseconds >> >> >creating connection with pool took: 585 miliseconds >> >> > >> >> >In my tests the connection pool is always slower, so what did I do >> >> wrong? >> >> >I guess this Parameter is responsible for holding active Connections >> in >> >> >the Pool: >> >> ><parameter> >> >> > <name>initialSize</name> >> >> > <value>20</value> >> >> ></parameter> >> >> >So there shold be active Connections before the getConnection( ) is >> >> >called .. Any ideas? >> >> >Regards, Henrik >> >> > >> >> >> >--------------------------------------------------------------------- >> >> >To unsubscribe, e-mail: [EMAIL PROTECTED] >> >> >For additional commands, e-mail: [EMAIL PROTECTED] >> >> >> >> >> >> >> >> >> >> This e-mail, including any attachments, is a confidential business >> >communication, and may contain information that is confidential, >> >proprietary and/or privileged. This e-mail is intended only for the >> >individual(s) to whom it is addressed, and may not be saved, copied, >> >printed, disclosed or used by anyone else. If you are not the(an) >> intended >> >recipient, please immediately delete this e-mail from your computer >> system >> >and notify the sender. Thank you. >> >> >> >> >> >> --------------------------------------------------------------------- >> >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> >> > >> >--------------------------------------------------------------------- >> >To unsubscribe, e-mail: [EMAIL PROTECTED] >> >For additional commands, e-mail: [EMAIL PROTECTED] >> >> >> >> >> This e-mail, including any attachments, is a confidential business >communication, and may contain information that is confidential, >proprietary and/or privileged. This e-mail is intended only for the >individual(s) to whom it is addressed, and may not be saved, copied, >printed, disclosed or used by anyone else. If you are not the(an) intended >recipient, please immediately delete this e-mail from your computer system >and notify the sender. Thank you. >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
