Toad World® Forums

Scalability Setup?


#1

I’m trying to run a test through BMF. I’ve set up a script w/ 3 sql statements. I can run them from benchmark. I running them from Toad they less than 2 minutes each. When I run the job from benchmark, it takes hours to get any results at all. I’ve set latency to nodelay. I’ve got User Loads set to Add Single User Load. Selected user loads of 1 and 4.

They are complex sql statements, but why would they take hours from BMF? Is there an issue with it returning a large number of rows?

Any suggestions would be greatly appreciated.


#2

It might have something to do with the number of rows returned. You can limit the number that BMF retrieves by setting the maximum rows returned in the BMF Settings - General tab.