Kathey Marsden wrote:
Perhaps this is a silly idea, but would using a function in the query that had a sleep in it make this more predictable? 10 rows each with a sleep of 3 seconds guaranteed to take 30 seconds.
It's not silly at all, it's in fact a very good idea. I have tried this approach and it works perfectly.
Using this technique, I don't have to rely on big data volumes, so I should be able to squeeze the test's running time down to less than a minute, at the same time making it completely predictable on any hardware, fast or slow. Thanks for the great idea!
-- Oyvind Bakksjo Sun Microsystems, Database Technology Group Trondheim, Norway http://weblogs.java.net/blog/bakksjo/
