SQL / Oracle适配器性能 [英] SQL/Oracle Adapter Performance
问题描述
我在业务流程中使用SQL Adapter从数据库中获取数据。轮询间隔设置为20秒。
SQL存储过程用于SQL适配器配置。 SP获取数据并在选择后将数据标记为已读取。
我想知道,
1)这会妨碍性能,因为Biztalk每隔20秒进行一次轮询和重新制作吗? br> 2)如何使用SQL Adapter提高性能。
我对Oracle Adapter也有同样的问题。
。Nilesh
当然BizTalk性能会受到影响,但我认为如果你不会产生巨大的性能影响每20秒处理一小部分数据。但我建议增加池化间隔
使用较低的池间隔值时,请小心将"将数据发现时的轮询"设置为false或启用它(如果您正在执行)在读取数据之前,正确的数据读锁定,因此可以避免SQL数据库中的多重读取重叠。
另一个重点,我认为限制来自数据库的数据大小非常重要服务器,一般规则不会获得所有可用数据。强烈建议使用前N语句为每个数据库读取一个可接受的数据块。
有关SQL Adapter最佳实践的更多信息,请参阅: http://msdn.microsoft.com/en-us/library/cc507804。 aspx
-Firas
Hi,
I'm using SQL Adapter in the orchestration to fetch the data from the database. The polling interval is set to 20 Sec.
SQL stored procedure is used in SQL adapter configration. SP fetches the data and marks the data as read after select.
I would like to know,
1) Would this hamper the performance as Biztalk is polling and repolling after every 20 sec?
2) How to improve the performace using SQL Adapter.
I have the same questions for Oracle Adapter as well.
.Nilesh
Sure BizTalk performance will be affected, but I don’t think it will be a huge performance effect if you have a small size of data to process every 20 seconds. But I recommend to increase the pooling interval
With low pooling interval value, be careful to set "Poll While Data Found " to false or enable it if you are doing proper data read locks before reading the data, so you can avoid the multiple read overlapping from SQL Database.
Another important point, I think it’s very important to limit the data size that comes from the DB servers, the general rule don’t get all the available data . it’s highly recommend to get an acceptable chunk of data for every DB read using the Top N statement.
For more information about the best practices for the SQL Adapter, refer to this: http://msdn.microsoft.com/en-us/library/cc507804.aspx
-Firas
这篇关于SQL / Oracle适配器性能的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!