ASP.NET应用程序不响应长SQL查询 [英] Asp.net application not responding on long sql queries

问题描述

嗨
Asp.net应用程序对长的SQL查询没有响应

在
上工作正常 .small data
在
上不起作用 .大数据

我们在
中实现了executetme 1. httpRuntime中的web.config
2. sql命令后面的代码

但仍然没有响应的问题.

问候

Zain

Hi
Asp.net application is not responding on long sql queries

working fine on
.small data
not working on
.large data

we implemented executiontme out in
1. web.config in httpRuntime
2. code behind on sql command

but not responding problem still exist.

Regards

Zain

推荐答案

首先，我想建议优化查询.为了优化查询，有很多可用的站点.我建议的是 http://blog.sqlauthority .com/2010/02/16/sql-server-stored-procedure-optimization-tips-best-practices/ [ http://www.4guysfromrolla.com/articles/031506-1.aspx [ ^ ]

First of all i would like to suggest to Optimize the query. For optimizing the query there are a lot of sites available. one I suggest is http://blog.sqlauthority.com/2010/02/16/sql-server-stored-procedure-optimization-tips-best-practices/[^]

Another is to return the data in chunk, instead of returning all the data at a time. see http://www.4guysfromrolla.com/articles/031506-1.aspx[^]

嗨Zain，

我遇到了一个问题.我使用存储过程而不是这么长的查询.最后，我得到了结果.

祝你玩得开心@@

Hi Zain,

I had come across such a problem.I used stored procedures instead of such long queries.Finally,i got the result.

Have a good time@@

这篇关于ASP.NET应用程序不响应长SQL查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！