Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.ms-sqlserver    |    Notorious Rube Goldberg contraption    |    19,505 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 19,261 of 19,505    |
|    Erland Sommarskog to Anton Shepelev    |
|    Re: Alternative to WAITFOR DELAY    |
|    29 Nov 17 22:49:29    |
      From: esquel@sommarskog.se              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.              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca