CODEWITHSUNDEEP
sqljmeter
kenji_getpowered
kenji_getpowered

Reputation: 358

JMeter - Launch Several SQL Requests

Context : I want to load test the database but the use case is a bit larger than a single request. For instance, with the GUI we can launch a payment. This means that our software will analyse each operation running on markets, will close operation, calculate an amount, send and log payment for accountancy. Each operation has a backup in the database (for recovery, security and accountancy).

Objective : It's a long use case but each operation is very short. I created a JDBC driver that logs each SQL operation. So I have a list of 2000ish operations that I want to replay to measure execution time.

Jmeter : I use Jmeter to test a single request. I can setup 2 or 3 requests but I want to tests a sequence of requests as explained

Upvotes: 2

Views: 1356

Answers (1)

UBIK LOAD PACK
UBIK LOAD PACK

Reputation: 34526

You can put your SQLs in a CSV file

Then use a CSV DataSet that will reference this file using variable sqlQuery

Then in JDBC Request use ${sqlQuery}

If you want the response time for the list of SQLs use Transaction Controller as parent of all JDBC Requests

Upvotes: 1

Related Questions