Connection pool

This article needs additional citations for verification. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed. Find sources: "Connection pool" – news · newspapers · books · scholar · JSTOR (October 2022) (Learn how and when to remove this message)

In software engineering, a connection pool is a cache of database connections maintained so that the connections can be reused when future requests to the database are required.^[1] Connection pools are used to enhance the performance of executing commands on a database. Opening and maintaining a database connection for each user, especially requests made to a dynamic database-driven website application, is costly and wastes resources. In connection pooling, after a connection is created, it is placed in the pool and it is used again so that a new connection does not have to be established. If all the connections are being used, a new connection is made and is added to the pool. Connection pooling also cuts down on the amount of time a user must wait to establish a connection to the database.