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,260 of 19,505   
   Anton Shepelev to All   
   Alternative to WAITFOR DELAY   
   29 Nov 17 23:38:36   
   
   From: anton.txt@gmail.com   
      
   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]   
      
   --- 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