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

• Connection pool is the collection of new, open and all type of database connections.
• Opening database connection is a time consuming operation.
• Connection pooling increases the performance of the applications by reusing the active database connections instead of creating new connection for every request.
• Connection pooling behaviour is controlled by the connection string parameters.

Following are the 4 parameters that control most of the connection pooling behaviour:

1. Connect Timeout
2. Max Pool Size
3. Min Pool Size
4. Pooling