loops - Extracting user details from a DB and using these to login via Jmeter -

i have db full of users (3 million) want use during testing, not want create or use csv file method this. pick new user each time login with.

in test plan have once controller have put jdbc connection db , 2 jdbc processors

1. one counts number of users in db $users
2. one selects emails in db fit criteria return an array of emails $emails

what struggling using these construct loop selects different email each time can pass these inputs login requests. each thread should use different email address.

are setting variable names textbox in jdbc sampler?

you can use _index notation access results returned jdbc sampler. example, if query returns single column of data, , put emails in variable names textbox, then:

emails_# contain number of result rows
emails_1 contain first row value
emails_2 contain second row value , on..

ref: jdbc sampler