Main Page | Report this Page
.NET DotNet Forum Index  »  ASP.NET Forum  »  How to void "time out" error?...
Page 1 of 1    

How to void "time out" error?...

Author Message
aspfun via DotNetMonster.com...
Posted: Wed Oct 28, 2009 12:37 pm
Guest
My app used store procedure to update data.
I some rush hour, users complain that they got "time out" error very often.
How to void it? It should be configured in web.config file or in ASP.NET code
file?

--
Message posted via DotNetMonster.com
http://www.dotnetmonster.com/Uwe/Forums.aspx/asp-net/200910/1
 
Mr. Arnold...
Posted: Wed Oct 28, 2009 12:55 pm
Guest
aspfun via DotNetMonster.com wrote:
Quote:
My app used store procedure to update data.
I some rush hour, users complain that they got "time out" error very often.
How to void it? It should be configured in web.config file or in ASP.NET code
file?


http://support.microsoft.com/kb/224587

You can also set the connection.Timeout property in the ADO.NET
connection when you open the connection in your code to give more time
than the default.

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectiontimeout.aspx

You can also have a poor performing network if it gets overloaded that
can cause the problem too.
 
Gregory A. Beamer...
Posted: Thu Oct 29, 2009 12:34 pm
Guest
"aspfun via DotNetMonster.com" <u53138 at (no spam) uwe> wrote in
news:9e477e79bcd3c at (no spam) uwe:

Quote:
My app used store procedure to update data.
I some rush hour, users complain that they got "time out" error very
often. How to void it? It should be configured in web.config file or
in ASP.NET code file?

As Mr Arnold stated, you can increase time out for connection and even
command, but this does not solve the root cause of the problem. I would
figure out why the update is so slow and start solving the actual problem
rather than simply make it look like there is no problem.

Peace and Grace,

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

Twitter: at (no spam) gbworld
Blog: http://gregorybeamer.spaces.live.com

*******************************************
| Think outside the box! |
*******************************************
 
 
Page 1 of 1    
All times are GMT - 5 Hours
The time now is Fri Dec 11, 2009 11:49 pm