procedure to sleep in sql
Is this something useful, or something stupid ?
create procedure sleep(howlong integer)
system 'sleep ' || howlong - 1;end procedure;
Or is there a better implementation, since the system call seems to be
quite expensive.
I need it for a select, that reports values (reads, writes) per second,
and my realtime display tool only wants one return value from
one statement block (it won't remember an old value).
Sounds tricky, doesn't it ?
Andreas Zeugswetter