db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Oyvind.Bakk...@Sun.COM
Subject Re: [jira] Updated: (DERBY-579) Query timeout set for one statement may affect other statements with the same SQL string
Date Fri, 30 Sep 2005 15:09:21 GMT
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

View raw message