When a connection to DB is opened using C# OPEN statement, does that impact the web server performance or only the Database? So, how does the repeated opening and closing of the database connection impact the web server and the database. Can somebody please give me some insight on this. Thanks.
A:
It impacts end-to-end response time, because of stuff going on in both the database and the web server. In short, your web pages will all load more slowly, even under light load.
Throughput-wise, it probably hurts the database more, since it's doing all the authentication work, but that's just a wild guess.
Marcelo Cantos
2009-12-29 06:16:05
There are caveats to this like how many connections are open, has the connection been previously opened and is in the pool, etc.
GrayWizardx
2009-12-29 06:17:23