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
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.
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)