https://bz.apache.org/bugzilla/show_bug.cgi?id=63561
Bug ID: 63561
Summary: enhancing the JDBC sampler to only fetch a certain
number of rows
Product: JMeter
Version: 5.1.1
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: Main
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: JMETER_5.2
How about enhancing the JDBC sampler to only fetch a certain number of rows
from the database (the result set of a select query)?
My use case is database load testing. In 99% of the cases I use the JDBC
sampler for, I am only interested in the time it took the database to run the
query.
I am not interested in the time it took the client (JMeter in that case) to
fetch the result set.
A BI client for example might run a query with a big result set, but maybe only
fetch the first 100 rows and not the whole result set.
Currently, there is no option in JMeter to do so.
Even when you set the "Count Records" option in JMeter, the whole result set is
fetched (in order to count the rows). There is no option to get the result set
size without fetching it (this is JDBC standard).
It is not an option to add a LIMIT clause at the end of the query, as databases
might have an optimization for that.
For the same reason, it is also not an option to use the JDBC parameter
ResultSet.setMaxRows(int).
I am only interested in knowing that the query has been processed successfully
(= didn't throw an error).
This is a new bug/feature request, I accidentally hijacked the following bug
initially:
https://bz.apache.org/bugzilla/show_bug.cgi?id=41921
--
You are receiving this mail because:
You are the assignee for the bug.
