Jmeter Multiple data for update query

Question

I am working on an update query using JMeter JDBC configuration. I have parameterized the input parameter and for now, it updates only one record as per the parameter value in each iteration. However, I want to update in bulk records to avoid long duration. Let's say I want to update 3k records at once. So how can I achieve this using JMeter parameterization for update query?

Answer 1

I think it's better to do it on SQL query level.

However if you need this to be done using JMeter:

1. Connect CSV Data Set Config and provide your 3000 parameters there

2. Configure JDBC Request sampler to read the data from the CSV file

3. Increase number of threads on Thread Group level to 3000

   

4. Add Synchronizing Timer to your thread group and set Number of Simulated Users to Group by to "3000"

   

This way JMeter will run the JDBC Request sampler with 3000 threads at exactly the same moment in time, hopefully this is what you're looking for