> From: Mike Stover [mailto:[EMAIL PROTECTED]] > > This is off-topic to this list. A quick answer is that it > depends on your database how many > times you can "re-use" a connection object. In JMeter's JDBC > testing, you can specify how > many times the connection pool allows each connection to be > reused. Thus, you can test the > difference in performance between reusing a connection only > once, or reusing it 1000 times > before re-initializing it. Just as an example, with MySQL, I > have found that re-using > connections more than 50 times starts to degrade performance > slightly. Recreating > connections to MySQL is so fast, that it's better to > re-initialize your connections frequently > rather than use old ones. I'm sure other databases are quite > different.
Quite interesting. Contrast that with Oracle's JDBC driver which can take a whole second or two to do its handshaking with the server. Obviously, reusing connections there will help a whole lot. -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
