Explain about Connection Pooling?
- Connection pooling is a concept which deals with database connection. A Connection Pool maintain last database connection active state when connection is ideal. Whenever you want to make a transaction with database once again you have to open connection when it is ideal, instead of that connection pooling will maintain open and reusable connections. A Connection Pool is released from the buffer or memory when the last connection to the database is closed.
- By default Connection Pooling turned on in ado.net; whenever you want to change it off, you have to specify Pooling = false in the connection string .
- We can specify limit to connection pooling by default the maximum limit is 100.
- You will specify in connection string.
- It will improves the performance and scalability of the application
It is managed by a program in ado.net that we called as Pool
Manager. This program will maintain different connection request by comparing with
maximum limit connection pool ,if number of connection are equal to max limit It
will wait for new connection till another connection ideal or time out. If connection is not in use then manager returns
one, else it will create new connection and add to the pool.
Connection
pool is managed with different parameters which are specified in connection string
those are
Connect
Timeout
Min Pool Size
Max Pool Size
Pooling
Min Pool Size
Max Pool Size
Pooling
Comments