The difference between the command timeout and connection timeout

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.

Thanks
Mahesh

+3
source share
2 answers

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.

, , . -, , .

+5

ConnectionTimeout - , DB

CommandTimeout - , SQL.

-, SQL , . , , .

+8

All Articles