- 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:
- Connect Timeout
- Max Pool Size
- Min Pool Size
- Pooling