Poll While Data Found

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Poll While Data Found

Viewing 1 reply thread
  • Author
    Posts
    • July 23, 2010 at 4:26 AM #25352
      community-content

        Hello.

        Does anyone knows the exact meaning of the proberty “PollWhileDataFound”?

        Does this means while a job is running the next poll will start after 30 seconds (standard value) so that there will be multiple job are running at the same time?

        I couldn’t find a hint to that in the help files. Is there somewhere a complete description of the properies available. 

        Thanks in advance.

        Wolfgang

      • July 23, 2010 at 11:14 AM #25355
        community-content

          Hi,

          On MSDN it is explained pretty clear:

          Specifies whether the SQL adapter ignores the polling interval and continuously executes the SQL statement specified for the PolledDataAvailableStatement binding property, if data is available in the table being polled. If no data is available in the table, the adapter reverts to execute the SQL statement at the specified polling interval. Default is false.

          Consider a scenario where the polling interval is set to 60 seconds, and the statement specified for PolledDataAvailableStatement returns that data is available for polling. The adapter then executes the statement specified for the PollingStatement binding property. Assuming that the adapter takes just 10 seconds to execute the polling statement, it will now have to wait for 50 seconds before executing the PolledDataAvailableStatement again, and then subsequently execute the polling statement. Instead, to optimize the performance you can set the PollWhileDataFound binding property to true so that the adapter can start executing the next polling cycle as soon as the previous

          http://msdn.microsoft.com/en-us/library/dd787981(BTS.10).aspx

           

           

           

          • July 26, 2010 at 1:06 AM #25367
            community-content

              Hi.

              Thanks a lot for your answer and your reply – no it is clear.

              Thanks for the link.

              Wolfgang

        • Author
          Posts
        Viewing 1 reply thread
        • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.