issues with connection pool for asp.net and ms-sql server
I have had problems with website ms-sql server connection pool getting full and/or timeout expiration. I have done the following.
1. on each page load i open the database
2. at the end of the page load i close the database connection
3. Every time i need to access the database i check if state is closed and i open it depending of the state.
4. On page unload i close the database connection
Do you think this is an efficient approach to my problem
Anthony
1. on each page load i open the database
2. at the end of the page load i close the database connection
3. Every time i need to access the database i check if state is closed and i open it depending of the state.
4. On page unload i close the database connection
Do you think this is an efficient approach to my problem
Anthony
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.