Subject | Re: [firebird-support] DELAY OR WAIT |
---|---|
Author | Ivan Prenosil |
Post date | 2004-12-13T10:06Z |
From: "Martijn Tonies"
Ivan
> > Are there any supported functions in SQL to doMartijn, I always thought you work with Windows, don't you ? :-)
> > command delay :
> > delay(msec)
> > or
> > wait(msec) ?
> >
> > lets say is system service stored proc :
> > while not (exists (select * blah blah)) do
> > begin
> > delay(1500);
> > end
> > If I run such statement without delay it would consume all CPU.
>
> No, there isn't.
>
> But what's wrong with consuming all CPU time? The server itself
> should schedule the threads.
Ivan