在存储过程超时中遇到问题 [英] facing problem in stored procedure timeout
本文介绍了在存储过程超时中遇到问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
实际上我是通过存储过程从数据库中获取用户记录的。我正在获取数据集中的记录并绑定到gridview。这里的问题是超时异常。 runnin存储过程需要很长时间。我把那个存储过程作为一个单独的查询并执行它需要32秒来执行查询......有没有任何解决方案来实现这个..
Actually i am getting user records from database through stored procedure. i am getting that records in dataset and binding to gridview. here problem is time out exception. runnin the stored procedure is taking much time. i taken that stored procedure as a separate query and executed it is taking 32 seconds to execute the query...is there any solution to over come this..
推荐答案
这种行为有以下几种原因......
有一系列步骤要做...
看看这里:
http://www.sqlbadpractices.com/ [ ^ ]
查询性能 [ ^ ]
使用SQL Server提高查询性能:第1部分 [ ^ ]
使用SQL Server提高查询性能:第2部分 [ ^ ]
使用统计信息提高查询性能 [ ^ ]
使用覆盖索引来提高查询性能 [ ^ ]
7个更快的SQL查询的性能提示 [ ^ ]
Sql Tutorial - 提高查询性能 [ ^ ]
There are several reasons of this behavior...
There is set of steps to do...
Have a look here:
http://www.sqlbadpractices.com/[^]
Query Performance[^]
Improving the performance of queries using SQL Server: Part 1[^]
Improving the performance of queries using SQL Server: Part 2[^]
Using Statistics to Improve Query Performance[^]
Using Covering Indexes to Improve Query Performance[^]
7 performance tips for faster SQL queries[^]
Sql Tutorial - Improving Query Performance[^]
这篇关于在存储过程超时中遇到问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文