Jmeter | Load million Telephone numbers from DB and hit 1 rest point using multiple threads

Viewed 17

I have a requirement where I have to load 1 million Telephone numbers from database and once that data is retrieved, need to call one REST endpoint using multiple threads. So I will load the data once and once data is loaded, use same dataset to hit rest endpoints concurrently.

I am a newbee to Jmeter and I am not able to figure out how to create thread groups to achieve this.

1 Answers

I would recommend

  1. Using setUp Thread Group to load the data from the database, there add:

    Check out How to Retrieve Database Data for API Testing with JMeter article for example implementation.

  2. Using normal Thread Group to create the concurrent requests:

    • CSV Data Set Config - to load the numbers from the CSV file so each virtual user would use the new number on next iteration
    • HTTP Request sampler to call your API
Related