SQL查询优化如何降低网络流量成本或避免超时错误 [英] SQL Query optimization how to reduce network traffic cost or avoid time out error

问题描述

运行带有大数据库查询的应用程序时，几乎在2:36秒内执行一次，因此我的应用程序会出现超时错误.优化sql查询的各种方法是什么.

when run application with large database query executed almost in 2:36 seconds so my application through time out error.what are the various ways to optimize sql query.

推荐答案

您将在Google上获得与此主题相关的更多链接.
现在看看下面的链接:-

http://blog.sqlauthority.com/2008/04/26/sql-server-optimization-rules-of-thumb-best-practices-readers-article/ [

You will get more links on google related this topic..
for now have a look on below links:-

http://www.mindfiresolutions.com/SqlServer-Query-Optimization-Tips-470.php[^]

http://blog.sqlauthority.com/2008/04/26/sql-server-optimization-rules-of-thumb-best-practices-readers-article/[^]

这篇关于SQL查询优化如何降低网络流量成本或避免超时错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！