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]
