Re: Which connection pool ??

[shankar]

Title: Which connection pool ??

Hi, It was a microsoft tool. I used a servlet and created the brokers in the init method. The servlet was loaded before the test began(so no init time). A simple nested query was used. I tried out 5 diff tests varying the threads from 20 to 500 and time from 1 min - 5 min. Can't say it's conclusive but hope its good enough. Bit Mechanic had a few add params that the others did'nt have. Performance will probably vary if these are changed. For this test I used a min of 2 connections and max of 10. If u do know of any better product please do tell us,I'm trying to figure out the best option for an app we are doing. thanks, Shankar. ----- Original Message ----- From: Dan Kesler To: '[EMAIL PROTECTED]' Sent: Wednesday, November 01, 2000 1:59 AM Subject: RE: Which connection pool ?? Shankar, Which stress tools did you use? Danny Kesler -----Original Message----- From: shankar [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 31, 2000 2:27 PM To: [EMAIL PROTECTED] Subject: Re: Which connection pool ?? Hi there, I trying to figure out the same thing and since I could'nt get a good answer anywhere, I tried out a stress test for diff drivers. I tried out DbConnectionBroker,BitMechanic,StanWeb(not sure of the name) and Oracles driver( which supports JDBC 2.0 SE ). DBConnectionBroker and Oracle came out tops(Oracles seemed the best). I used Microsofts stress testing tool and used the same set of parameters for all of them. If u do plan to use Oracle go in for 8.1.7 since 8.1.6 has'nt been properly tested and is just a sample implementation according to their JDBC team. Will send u the exact results if u do want them(will have to wait a day though- won't be in tomm). Here's my id - [EMAIL PROTECTED]. If u do manage to find something better please mail me. Hope this helps. Shankar. ----- Original Message ----- From: Arnout Kuiper To: [EMAIL PROTECTED] Sent: Tuesday, October 31, 2000 9:10 PM Subject: RE: Which connection pool ?? I use JDBCPool from http://www.bitmechanic.com/.     --Arnout -----Original Message----- From: Kieffer, Guillaume [mailto:[EMAIL PROTECTED]] Sent: dinsdag 31 oktober 2000 16:20 To: '[EMAIL PROTECTED]' Subject: RE: Which connection pool ?? I do not know if it is th elatest version, but it works great... Regards, -----Original Message----- From: Laufer, Michael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 31, 2000 3:34 PM To: 'Struts' Subject: Which connection pool ?? Hi, I'm programming with Struts. Since I have a lot of 'database traffic', I'm thinking about using a connection pool. Has anybody any experience in using connection pools with Struts. Even better, if there would be a freeware connection pool. Any help would be appreciated. Thanks, Mike