SQL Server 2005 和 .NET 之间的延迟

发布于 2024-08-02 05:53:21 字数 742 浏览 6 评论 0原文

我写了一个简单的程序，如下所示。

string s;
do
{
  using (SqlConnection conn = new SqlConnection("POOLEDCONN"))
  {
    using (SqlCommand cmd = new SqlCommand("", conn))
    {
        s = (string) cmd.ExecuteScalar();
        Code2IncrementPerfomanceCounter
    }
  }    
} while (!string.IsNullOrEmpty(s))

查询返回一个字符串（nvarchar(max)，当前最大大小9k），SQL Server和.NET之间存在很大的延迟。 SQL Profiler 说查询的持续时间为 0 毫秒，所以我认为这不是数据库的问题。网络在不到 1 毫秒的时间内做出响应，因此不应是网络问题。

如果我在我们的测试服务器（VMWare，SQL 未虚拟化）上运行此代码，每秒最多将有 600 个循环。该应用程序不会消耗超过 5% 的 cpu。为什么不进展快点？我必须使用流式传输从 SQL 或其他方式获取数据吗？

提前感谢

原文

This question is an follow-up of an previous asked question.

I've written an simple program who looks like this.

string s;
do
{
  using (SqlConnection conn = new SqlConnection("POOLEDCONN"))
  {
    using (SqlCommand cmd = new SqlCommand("", conn))
    {
        s = (string) cmd.ExecuteScalar();
        Code2IncrementPerfomanceCounter
    }
  }    
} while (!string.IsNullOrEmpty(s))

The query returns an string(nvarchar(max), current maximum size 9k), there is a lot of latency between SQL Server and .NET. The SQL Profiler says that the query has an duration of 0 ms, so I think it isn't the database. The network is responding in less than 1 ms so it shouldn't be the network.

If I run this code on our testserver(VMWare, SQL isn't virtualized) there will be a max of 600 loops per second. The application doesn't consume more than 5 % cpu. Why isn't it going
faster? Must I use streaming to get the data from SQL or something else?

Thanx in advance

分享到QQ

分享到微博