ODBC具有SetRowsetSize，ADO.net中的等效项是什么？

问题描述

我正在寻找处理高延迟连接的方法。 ODBC具有 SetRowsetSize 可以解决此问题，如和。

在ADO.net中是否具有与该设置等效的功能？ 似乎暗示

通常来说，如何提高ADO.net中的高延迟连接性能？

？

解决方案

如果您担心将ADO.NET与SQL Server一起使用时的延迟，则应研究。尽管请注意。

此外，如果您需要快速检索许多记录，请使用。与使用其他类型的ADO.NET对象（如数据集）相比，它所需的内存要少得多，并且已对其进行了优化以有效地获取大量数据。

有某些，您可以查看它的数量活动连接池（ NumberOfActiveConnectionPools ）以及其他有用信息。

。

I am looking for ways to deal with a high latency connection. ODBC has a SetRowsetSize that solves this problem, as described here and here.

Is there an equivalent of this setting in ADO.net? This article seems to suggest there is an analog in the original ADO, but it is very old and points to articles that no longer exist.

Generally speaking, how does one improve performance in ADO.net for high-latency connections?

解决方案

If you are concerned about latency while using ADO.NET with SQL Server, you should to look into connection pooling. Though be mindful of pool fragmentation.

Additionally, if you need to retrieve many records rapidly, look into using the SqlDataReader. It requires significantly less memory than a using other types of ADO.NET objects like DataSets and its optimized for efficiently fetching large amounts of data.

There are certain performance counters you can look at to see the number of active connection pools (NumberOfActiveConnectionPools) along with other useful information.

Step by step guide on how to test.

这篇关于ODBC具有SetRowsetSize，ADO.net中的等效项是什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！