All geek questions in one place

IIS connection timeout and connection string timeout attribute

I am confused in these two terms. I want to know what is the difference between timeout inside the connection string and timeout inside the IIS configuration.

data source=xxxx;Initial Catalog=Test;User=yy;Password=yyyy;Timeout=10

enter image description here

+4
source share
2 answers

Database connection timeout is very different from IIS timeout

The connection timeout to the database is to establish a connection to the database, from MSDN SqlConnection.ConnectionTimeout

Gets the timeout when trying to establish a connection until the attempt completes and an error is generated.

From MSDN about connection timeout

Connection timeouts reduce the amount of memory resources consumed by idle connections. Timeout settings also allow you to specify how much server resources are allocated for specific tasks or clients.

+2
source

The timeout in the database connection string is the time during which ADO.NET must try to connect to the database server before deciding that it is unavailable (which is not related to the command timeout, note). Connect in the database connection string is synonymous with Connect Timeout .

IIS timeout is how long it should take to process the request before deciding that it failed.

+1
source

Source: https://habr.com/ru/post/1484594/

More articles:


All Articles