home bbs files messages ]

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