Correlating Queries to Optimize a Script

Database Vuser Scripts · Correlating Database Statements

Creating Vuser Scripts

Chapter 10, page 175

Correlating Queries to Optimize a Script

When performing multiple, dependent queries, you can use correlated queries to

optimize your script. Instead of waiting for the result of one query before performing

the second, you can link between two queries. This feature is particularly useful in

load testing, where you perform similar queries several times, using different

parameters. The following sections illustrate linked queries for:

simple queries (without binding)

queries with binding

queries using binding with output placeholders