Koopman_Interna
13 years agoContributor
Performance multiple JDBC requests
When I run multiple small JDBC requests as separate teststeps, say 30 in a row to retrieve 1 record each in 30 different tables, I see the following strange behaviour:
Running 1 teststep manually shows in the Request Log of the JBDC teststep it takes about 16ms. This is pretty consistent, although sometimes 0ms is reported or 31ms. But no intermediate values.
When I run the same requests in a combined Run step, the requests all take about 250ms each.
Where is this overhead coming from? I would like it if the 30 fetchrequests would take 30 x 16ms instead of 30 x 250ms !
(I am running 100 tests from an Excel sheet that each run the 30 JDBC requests before invoking one soap request, so the JDBC requests take about 100 x 30 x 250ms = 750s)
I tested on a much faster PC, no improvement. I use the IBM DB/2 on iSeries JDBC driver (jt400.jar).
The performance is the same for 3.6.1 and 4.0.0.
Running 1 teststep manually shows in the Request Log of the JBDC teststep it takes about 16ms. This is pretty consistent, although sometimes 0ms is reported or 31ms. But no intermediate values.
When I run the same requests in a combined Run step, the requests all take about 250ms each.
Where is this overhead coming from? I would like it if the 30 fetchrequests would take 30 x 16ms instead of 30 x 250ms !
(I am running 100 tests from an Excel sheet that each run the 30 JDBC requests before invoking one soap request, so the JDBC requests take about 100 x 30 x 250ms = 750s)
I tested on a much faster PC, no improvement. I use the IBM DB/2 on iSeries JDBC driver (jt400.jar).
The performance is the same for 3.6.1 and 4.0.0.