On 16 February 2012 20:02, James Carr <[email protected]> wrote: > Hi All, > > > > I ran these tests several times, and each time I come back with the similar > results. I really don't get it. I am using JDBC sampler with max connections > set to 30 for running across 3 machines and 90 when running on one machine. > Here's the results: > > > 30 Threads x 3 Machines for 2 minutes > > > > > > > > > > > > > > > > > > > > > Number of Samples: 176,912 > > Average Response: 62 > > Std. Deviation: 436.46% > > > 90 Threads x 1 Machine for 2 minutes > > > > > > > > > > > > > > > > > > > > > Number of Samples: 912,954 > > Average Response: 11 > > Std. Deviation: 34.14% > > > > > > Machine Specs: > > RAM: 8GB > > Processor: Intel Core i7 CPU 870 @ 2.93Ghz > > System Type: 64-bit Windows 7 > > > > Any idea why I see this huge discrepancy? I have double checked on our > database on the server side and I verified that we do have the number of > connections we expect to see, but I can't understand why the performance > looks so lousy with multiple machines. >
I'm not sure it makes sense to share JDBC connections between threads if the threads are supposed to represent independent users. I suggest you set the "Max Number of Connections" to 0; this will use a single connnection for each thread. > > > > Thanks, > James > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
