What is the difference between connection timeout and command timeout?
In our application, a timeout error is sometimes displayed. When we increased the timeout value of the command to 100 (the default is 30), its work. Is there a problem in increasing the timeout value of the command.
ThanksMahesh
As mentioned, the connection timeout is the time to establish a connection to the database server. A team timeout is a timeout for a command to execute.
, ASP.NET - . Server.ScriptTimeout httpRuntime/@executionTimeout. .NET 2.0+ 110.
Server.ScriptTimeout
httpRuntime/@executionTimeout
, , . -, , .
ConnectionTimeout - , DB
CommandTimeout - , SQL.
-, SQL , . , , .