Opertation有超时;在多个用户访问时登录屏幕上。 [英] Opertation has Timeout ; on Login screen when more than 1 user access.

问题描述

Opertaion有超时



我在My Project中使用（我自己的）WebMethods，当更多只有1位用户在登录时访问显示错误Opertation has Timeout屏幕和另外1个地方有5-6个表在查询中加入，显示服务器无法处理请求。

对于这个问题我试过可能的解决方案

1.Added Connect 超时= 5000;池=真;连接字符串中的最大池大小= 200; 。

2.在

 < <中添加/ span> 系统    Web  >  <   httpRuntime       executionTimeout   =  5000    maxRequestLength   =  2097151  /  >  

3.在我的函数中添加SqlCommand.CommandTimeout = 5000;

4.增加远程查询超时从Sql Server使用sp_Configure。



但是S直到得到相同的问题，如果有人知道，请建议我。

提前谢谢。

解决方案

超时仍然很低。但是，总的来说，这听起来像你的表设计或SQL是非常低效的。你可以尝试在你的select语句中添加''nolock''，这样他们就不会锁定表格，但我怀疑如果你不能让两个人一次登录就需要更完整的重新设计。 / BLOCKQUOTE>

Opertaion has Timeout

I m using (My own)WebMethods in My Project, when more hen 1 user access the showing error "Opertation has Timeout" on Login screen and 1 more place when have 5-6 tables joined in query, there showing "Server was unable to process request".
For this problem i tried may solutions
1.Added Connect Timeout=5000; pooling=''true''; Max Pool Size=200; in Connection string.
2. Added in

<System Web><httpRuntime  executionTimeout="5000" maxRequestLength="2097151"/>

3.Added in my function SqlCommand.CommandTimeout=5000;
4.Increased "Remote Query Timeout" from Sql Server usinf sp_Configure.

But Still getting same issue, If any one knows, Please suggest me.
Thanks in advance.

解决方案

The timeout is still pretty low. But, overall it sounds like your table design or SQL is very inefficient. You can try adding ''nolock'' to your select statements, so they don''t lock the tables, but I suspect a more complete redesign is needed, if you can''t get two people to log in at once.

这篇关于Opertation有超时;在多个用户访问时登录屏幕上。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！