What is a connection pool?

What is a connection pool?

Rating:

A connection pool is created when a database connection is opened for the first time. It is created based on an exact matching algorithm with that of the connection string in the database connection. A database connection is maintained in a database's cache memory. The database connection in the connection pool can be reused when a user sends data requests to the database. Hence, there is no need to establish new connections for the same database. However, when a new database connection is opened and the connection string does not match with an existing pool, a new connection pool is created. Each connection pool in a database can be associated with a distinct connection string.

A connection pool enhances the performance of executing data commands on a database. If a database connection is opened and maintained for each user, it can become very expensive and a lot of the server resources will be wasted. However, by enabling connection pooling, the amount of time a user has to wait for a database connection to be established on the database can be cut down.

Rating: