Interview Questions

What is connection pooling and how do you make your application use it?

.NET Interview Questions and Answers


(Continued from previous question...)

What is connection pooling and how do you make your application use it?

Opening database connection is a time consuming operation.
Connection pooling increases the performance of the applications by reusing the active database connections instead of create new connection for every request.
Connection pooling Behaviour is controlled by the connection string parameters.
Follwing the the 4 parameters that control most of the connection pooling behaviour.
1. Connect Timeout
2. Max Pool Size
3. Min Pool Size
4. Pooling
Please go through the following link as well
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q169470

(Continued on next question...)

Other Interview Questions