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

Popular posts from this blog

c++ - QTextObjectInterface with Qml TextEdit (QQuickTextEdit) -

javascript - angular ng-required radio button not toggling required off in firefox 33, OK in chrome -

xcode - Swift Playground - Files are not readable -