SqlDataAdapter.Fill()超时-基本Sproc快速返回 [英] SqlDataAdapter.Fill() Timeout - Underlying Sproc Returns Quickly

问题描述

我有一个SqlDataAdapter，其中填充了21行数据(4列).驱动它的存储过程在SQL Mgmt Studio中会在几秒钟内返回，但是.Fill()需要5分钟.

I have a SqlDataAdapter that is being populated with 21 rows of data (4 columns). The sproc that drives it returns in a couple seconds in SQL Mgmt Studio, but the .Fill() takes 5 minutes.

    ArrayList ret = new ArrayList();
    SqlDataAdapter da = null;
    SqlCommand cmd = null;  
        cmd = base.GetStoredProc("usp_dsp_Stuff"); //Returns immediately in MSSMS.
        cmd.CommandTimeout = 3600; // Set to 6 min - debug only
        base.AddParameter(ref cmd, "@Param1", ParameterDirection.Input, SqlDbType.BigInt, 8, 19, 0, theParam1);
        base.AddParameter(ref cmd, "@Param2", ParameterDirection.Input, SqlDbType.BigInt, 8, 19, 0, theParam2);
        base.AddParameter(ref cmd, "@Param3", ParameterDirection.Input, SqlDbType.Char, 1, 'C');
        da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt); //Takes 5 minutes.

有什么想法吗?

提前谢谢！ -克里斯

推荐答案

da = new SqlDataAdapter(cmd);
da.SelectCommand.CommandTimeout = 1800;

这篇关于SqlDataAdapter.Fill()超时-基本Sproc快速返回的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！