https://bz.apache.org/bugzilla/show_bug.cgi?id=41921
Franz Schwab <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |NEW --- Comment #9 from Franz Schwab <[email protected]> --- Hi Philippe! Thank you for your quick response. 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). Yes, the code provided in the S.O. link only fetches one row. Best regards, Franz -- You are receiving this mail because: You are the assignee for the bug.
