Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1999

Re: Alternative to WAITFOR DELAY

Show all headers | View raw

Anton Shepelev (anton.txt@gmail.com) writes:
> Is there a more granular way to ease a tight polling
> loop in T-SQL than WAITFOR DEALAY?  A delay of  3.33
> milliseconds being a tad too long for my purposes, I
> seek a way to implement delays of about half a  mil-
> lisecond or shorter.  I do not need the precision of
> real-time systems and will accept  any  solution  to
> prevent a fast WHILE 1=1 loop from hogging the CPU.
> 

I guess that you could write a CLR procedure for the task.

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Alternative to WAITFOR DELAY Anton Shepelev <anton.txt@gmail.com> - 2017-11-29 23:38 +0300
  Re: Alternative to WAITFOR DELAY Erland Sommarskog <esquel@sommarskog.se> - 2017-11-29 22:49 +0100
    Re: Alternative to WAITFOR DELAY Anton Shepelev <anton.txt@g{oogle}mail.com> - 2017-11-30 13:58 +0300

csiph-web