在存储过程超时中遇到问题 [英] facing problem in stored procedure timeout

查看:99
本文介绍了在存储过程超时中遇到问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

实际上我是通过存储过程从数据库中获取用户记录的。我正在获取数据集中的记录并绑定到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屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆