Sign in
Write Ahead Blog
rushi desai | developer | zune service
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
Blog Home
Email Blog Author
Share this
RSS for posts
Atom
RSS for comments
Search
Tags
No tags have been created or used yet.
Archive
Archives
November 2007
(1)
September 2006
(2)
April 2006
(1)
December 2005
(3)
November 2005
(1)
September 2005
(3)
June 2005
(4)
May 2005
(4)
April 2005
(2)
March 2005
(9)
February 2005
(11)
WAITFOR (RECEIVE ...) does not poll!
MSDN Blogs
>
Write Ahead Blog
>
WAITFOR (RECEIVE ...) does not poll!
WAITFOR (RECEIVE ...) does not poll!
Rushi Desai
19 Mar 2005 6:47 AM
Comments
0
A lot of people have been concerned about using the WAITFOR (RECEIVE ...) statement for receiving Service Broker messages from a queue. Several believe that this would poll the queue continuously until messages become available in the queue either by another transaction enqueueing messages or a lock that was previous held being released. The polling wary have asked for an alternative notification based mechanism to fix this. For all you guys.. relax! WAITFOR (RECEIVE ...) does not poll. It does not consume any processor cycles on the server side or the client side (assuming that ADO.NET indeed uses IO completion ports). The only thing you are possible using up is a thread that blocks until a result set is available. If you do not want to sacrifice your thread, go ahead and use
BeginExecuteReader
while posting your WAITFOR(RECEIVE ...) statement from ADO.NET.
0 Comments
Blog - Comment List MSDN TechNet
Comments
Loading...