Just FYI, historically, JMeter's connection pool comes from dealing with databases like Access, Foxpro, and Interbase, and I found that if a connection was allowed to be reused over and over again, memory leaks occurred in the very old jdbc drivers I was using (this was 5-6 years ago), and a maximum reuse setting was useful for clearing the memory. I've also found that mysql performs much faster with fairly low max reuse settings (like around 50), which seems odd, but there it is.
I realize most connection pools don't even have this setting these days, and don't seem necessary for most modern drivers. -Mike On 10 Aug 2003 at 20:58, Jeremy Arnold wrote: > Hello, > Having the reuse number set to 1 also makes it a pretty unfair > performance comparison between the new code I sent and the original > JMeter code. My new code will currently always reuse the connections, > so it's like having the reuse number set to infinity. Since it looks > like the new code is going to work okay, I'll have to do some additional > investigation to try to incorporate the reuse number or have some other > way to do more fine tuning of the pool. Having a reuse count doesn't > really fit too well with the new model, although it could probably be > done. On the other hand, I think this new code is probably closer to > how most J2EE DataSource implementations do connection pooling -- > reusing a connection unless it times out or fails in some odd way. > > Anyway, thanks for the input. Please let us know if you learn > anything else, or if you encounter any problems with the new code. I'll > do some more cleanup and investigate the above issues some more and then > commit it to CVS if/when I get something workable. > > Jeremy > > > [EMAIL PROTECTED] wrote: > > >Did you try upping the reuse number? Reuse of 1 defeats the whole point of > >having a database pool. > > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > -- Michael Stover [EMAIL PROTECTED] Yahoo IM: mstover_ya ICQ: 152975688 AIM: mstover777 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
