Connection pool
In software technology, a connection pool is a cache of existing database connections that is used for queries.
Since setting up a new connection to the database takes time and ties up computer resources (e.g. in the context of a web application ), a new connection is not created for every request. Instead, a connection from the connection pool is used. Connection pools thus improve the speed of execution and reduce resource consumption.
In the case of a web application, the "connection pool" is usually managed by the application server . If the application wants to open a connection to the database, the application server in the background provides a connection from the pool to the application. When the application closes the connection, it is put back into the pool by the application server.
Connection pooling is supported by IBM DB2 , Microsoft SQL Server , Oracle , MySQL and PostgreSQL .
See also
credentials
- ^ IBM Connection Pooling Support
- ↑ SQL Server Connection Pooling (ADO.NET)
- ^ OCI Driver Connection Pooling
- ↑ MySQL Connection Pooling ( Memento of the original from October 26, 2011 in the Internet Archive ) Info: The archive link was automatically inserted and not yet checked. Please check the original and archive link according to the instructions and then remove this notice.
- ^ PostgreSQL Replication, Clustering and Connection Pooling
