Testing Concurrent DB Connections
I want some information on testing database queries. Also any help, suggestion or tool which would lead me for testing different number of concurrent connections and acording to this enables me to monitor the response time of the application on different concurrent connections
Re: Testing Concurrent DB Connections
There are many ways to approach this, but here are few that come to my mind.
1.) Use JUnit with JDBC and scale the load with JUnitPerf.
2.) Use Perl and write a multi-threaded load test.
3.) Create ASP/JSP(JDBC) pages to interact with database and use a load tool to simulate it.
For me, JUnit and JUnitPerf would make sense since you have more direct control, it's free, and developers can help you write it.