Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

IIS connection timeout and connection string timeout attribute

Tags:

c#

asp.net

iis

I'm confused in those two terms I want to know what is the difference between the timeout inside the connection string and the timeout inside the IIS configuration

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

enter image description here

like image 936
Sora Avatar asked Jun 05 '13 08:06

Sora


1 Answers

DB connection timeout is very diffrent from IIS time out

DB connection timeout is about establis the connection to DB, from MSDN SqlConnection.ConnectionTimeout

Gets the time to wait while trying to establish a connection before terminating the attempt and generating an error.

From MSDN about Connection Timeout

Connection timeouts help reduce the amount of memory resources that are consumed by idle connections. Time-out settings also allow you to specify how long server resources are allocated to specific tasks or clients.

like image 179
Mzf Avatar answered Oct 04 '22 13:10

Mzf