WCF-SQL适配器：轮询间隔问题 [英] WCF-SQL Adapter: Polling Interval issue

问题描述

 我有一个简单的passthru确保我从数据库中提取数据。

WCF-SQL Adapter正在以太快的速度提取数据。我开始它，当我停止它（开始后不久），我有成千上万的文件。这不应该发生。我将轮询间隔设置为3000（我甚至将其设置为30000秒）。然而它只是
通过轮询以毫秒为单位飞行。它正在轮询这么快，其中许多消息最终都在暂停的队列中。

关于可能发生什么的任何想法？

解决方案

您好

有一个类似的线程< a href ="http://social.msdn.microsoft.com/Forums/nl-NL/biztalkr2adapters/thread/9ea027ac-24ec-4377-ba61-ce5f223e0b94\"target ="_ blank">
here ，这可能会有所帮助。有关于设置事务隔离属性的建议。请参考

here  关于财产的详细信息。

HTH

Naushad

 I have a simple passthru going to make sure that I was pulling data from the database.

The WCF-SQL Adapter is pulling data way too fast. I start it and by the time I stop it (soon after starting), I have thousands of files. that should not happen. I have the polling interval set to 3000 (I have even set it to 30000 seconds). And yet it just flys thru polling in milliseconds. It is polling so fast many of these messages end up in the suspended queue.

Any ideas on what could be happening?

解决方案

Hi

there is a similar thread here, which might be helpful. There is a suggestion about setting Transaction isolation property. Please refer here about the details of property.

HTH

Naushad

这篇关于WCF-SQL适配器：轮询间隔问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！