随着时间的推移，存储过程返回的数据集变得非常慢。如果重新编译存储过程，则速度很快。

我正面临着使用存储过程从数据库中提取记录的问题。我们的环境是ASP.NET 2.0 Web应用程序和SQL Server 2008.我们正在使用Microsoft Data Access Application Block dlls。

代码如下：
Dim dbLegal As Database = DatabaseFactory.CreateDatabase（CONNECTION_STRING）
Dim dbCmdLegal As DbCommand = dbLegal.GetStoredProcCommand（PROC_ATS_ORDER_SEARCH）
设置输入参数
searchList = dbLegal.ExecuteDataSet （DBC mdLegal）

现在的问题是，如果我们编译存储过程，记录将在3-4秒内获取。但是经过几天相同数量的记录，开始花费越来越多的时间，最终导致超时错误。虽然独立存储过程花费的时间较少。如果我们重新编译存储过程，整个过程会变得更快。除了增加CommandTimeout属性之外，还有什么可能解决这个问题？请建议。

Hi,
I am facing an issue regarding records being fetched from database using a stored procedure. Our environement is ASP.NET 2.0 web application and SQL Server 2008. We are using Microsoft Data Access Application Block dlls.

The code is like below:
Dim dbLegal As Database = DatabaseFactory.CreateDatabase(CONNECTION_STRING)
Dim dbCmdLegal As DbCommand = dbLegal.GetStoredProcCommand(PROC_ATS_ORDER_SEARCH)
Set Input parameters
searchList = dbLegal.ExecuteDataSet(dbCmdLegal)

Now the issue is, if we compile the stored procedure the records are fetched within 3-4 seconds. But after a few days the same number of records, start taking more and more time, eventually resulting in timeout error. Though the stand alone stored procedure takes lesser time. Again if we recompile the stored procedure the whole process becomes faster. This issue goes on recurring in the

What can be a probable solution to this other than increasing the CommandTimeout property? Please suggest.