sql - jMeter: randomizing queries across an list of key values -
i using jmeter conduct series of database load tests. database table contains several billion transactions ~500k key values. need issue queries retrieve records randomized key values. easy if key values numeric , consecutive, randomize across numeric range of values (0 .. 500000) - strings, need extract distinct list of key values first jmeter can pick random values issue queries. can query key values database, or place them in csv @ start of each test run. performance test, , machine has lots of memory, prefer if jmeter can load key values memory before beginning test.
i dont know best technique use configure jmeter pick randomized values list - there technique this?
thanks!
i believe __stringfromfile function can help. reads next string input file (or multiple files) each time being called. when end of file reached function starts on beginning. extended information on using , other jmeter's functions check how use jmeter functions post series.
Comments
Post a Comment