Just getting started with Benchmark Factory sp apologies in advance for the stupid question - maybe I’m coming at this completely the wrong way
I want to test a stored procedure that executes a lot of comoplicated stored procedures. This Main stored procedure takes a single integer parameter value (“key Value”)
To provide a list of viable Key values to be passed to the the SPROC I have created a lookup table of 1 million rows (1 million unique key vals) each with a sequential rownum for use as a means of generating a good keynnum value for the parameter to the sproc. Table looks like this (the keyvals are non sequential and basically random trying to to randomly pick a keyval would have a high miss rate)
The plan is to pass a random number to the BF scalability job that calls the stored procedure (I want to test something like $BFURandRange(1,1000000) ) and then the agent uses that random number to go to the lookup table table and get the key value for the matching RowNo value and pass it to the sproc via the bound sproc parameter value
However the problem is that it just picks the same number every time and so I end up erroring out after 5 rows. How can I make it pick a different random number for Rowno each time so that I can get a different keyVal each time?
And to really put the bonus icing on the cake how can I guarantee that it never picks the same random number more than once?
Thanks a million for any insight - as I say, maybe I’m coming at this completely the wrong way