Last post Oct 16, 2009 12:24 AM by maxi_ng
Oct 15, 2009 06:41 AM|maxi_ng|LINK
I want to do so such that I can manage connections and reduce connection creation overhead, etc.
How am I able to do that?
Oct 15, 2009 10:12 AM|sirdneo|LINK
See this article, this will help you to understand connection managment:-
Tuning Up ADO.NET Connection Pooling in ASP.NET Applications
Oct 15, 2009 10:27 PM|maxi_ng|LINK
Thank you, this article shed some light on my question.
I am wondering what the article described.
Does it means IIS is automatically handling connection pooling regarding the connection string?
If so, then I have some questions to ask.
1. What is there are two requests come to my server querying data from the database with different connection pool setting? What will happen to my pool?
2. Does it means new SqlConnection(connectionString); is acquiring connection from the pool and connection.Close(); means returning it?
3. What connections are in one pool? will different authentication end up in same pool? different login to the same database end up in same pool?
Oct 16, 2009 12:24 AM|maxi_ng|LINK
I found my answers, thank you.