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

Alternative to WAITFOR DELAY

From	Anton Shepelev <anton.txt@gmail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Alternative to WAITFOR DELAY
Date	2017-11-29 23:38 +0300
Organization	A noiseless patient Spider
Message-ID	<20171129233836.16edaac99510193c72857910@gmail.com> (permalink)

Show all headers | View raw

Hello, all

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.

-- 
()  ascii ribbon campaign -- against html e-mail
/\  http://preview.tinyurl.com/qcy6mjc [archived]

Back to comp.databases.ms-sqlserver | Previous | Next — 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