Hi,
Quick note: I still think that *load* test against virtual service will not provide useful results. *Performance* test might work, but not load one.
Nevertheless...
Based on the description from https://support.smartbear.com/readyapi/docs/servicev/configure/datasources.html#how-it-works, I got it that the data query is executed on service start and returned dataset is static.
As you need dynamic dataset, the only idea that I have at the moment is to use ADO to get data from the database. Depending on the size of the database, I see two options for the implementation.
a) If the database is small, you can extract all data from the database and filter them later.
In order to do this, create MockRunListener.onMockRunnerStart event (https://support.smartbear.com/readyapi/docs/testing/handling-events.html#available-events) and add code that creates ADO.Recordset instance and fills it with the data from the database. (I know that in order to preserve resources, the obtained recordset can be disconnected from the database in VBScript code. Disconnection is not possible with JScript and I am not sure about Groovy - needs to be checked.) Obtained recordset should be preserved into (assigned to) the project global property (say, GetPerson). Then, in the response dispatch script, you should get the value of the SSN and filter the recordset (by setting its .Filter property to the SSN value). Use returned filtered value to craft the contents of the response.
b) If the database is large, then it may be too expensive to keep all data in the memory-based recordset. In this case in the MockRunListener.onMockRunnerStart event you may just open the connection to the database, attach this connection to the empty dataset and preserve the dataset in the public property. Then, within the response dispatch script you should provide this empty template dataset with the proper SQL statement and execute it to get the data.
