Unique and not reused databank
For our application, once a particular data record has been tested, it cannot be reused due to business logic restrictions. Per https://support.smartbear.com/loadninja/docs/use-cases/data-driven...
Forum Discussion
Hi JasonCoyne
Your understanding off the unique feature is correct, its at the same time.
Afaik there is nothing in the tool that will enable this per say
However....
If you want to ensure unique instances each time it may make more sense to run a script against the DB to take care of this prior to load testing.
This would be the only real way to guarantee unique instances each time you run a load test
KR
Vinnie
vinniew Im not sure how running a db script could solve the problem?
If I have a databank with 10,000 users, and I am running 50 simultaneous users : then I want them all to read through the 10,000 users either sequentially or randomly, but such that any given user was not run twice. How would running a database script help that?
Does "at the same time" mean "exactly the same moment", or "during the test execution"?
If I had 50 users in the databank, and 50 simultaneous tests, would each test only run 1 user?
Hi Jason,
This can be done easily:
Instead of running your test for a specified duration, run a certain number of iterations per VU.
You have 10,000 rows of data, and 50 VUs. Therefore, you just need to configure your scenario to use 50 Vus and to have each one of them run 200 iterations. 50 X 200 = 10,000.
MPunsky What coordinates the VUs to not reuse the same record from the databank?
Hi Jason,
I see that this will not solve your issue unfortunately. The way that the current UNIQUE works is that it assigns a row to each VU and they use that same row for every iteration. We have new databanks coming out soon and we will be sure to include the feature you need, plus a number of additional enhancements.
The Configuration matrix that has been requested is:
