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
Some discussion already took place here: https://github.com/frschwab/jmeter/commit/102f0ac58af82a28e01565047f3d114366996231
Pull request: https://github.com/apache/jmeter/pull/476
Merged in trunk: https://github.com/apache/jmeter/commit/ab9770b88bef2e99f61af0388a9c8e61de940f23
没有中文汉化
This issue has been migrated to GitHub: https://github.com/apache/jmeter/issues/5118