Connection Pool

Under a Connection Pool is understood in software engineering a cache of existing database connections to be used for requests.

Since the establishment of a new connection to the database takes time and computing resources binds ( eg in the context of a web application ), a new connection is not created for each request. Instead, a connection from the connection pool will be used. Connection pools improve the speed of execution and reduce resource consumption.

In a Web application, the " Connection Pool " is usually managed by the Application Server. If the application tries to open a connection to the database in the background of the Application Server is a connection from the pool for use. Closes the application connection, then this by the application server is placed back into the pool.

Connection pooling is supported by IBM DB2, Microsoft SQL Server, Oracle. , MySQL and PostgreSQL

Credentials

  • Databases
Cache (computing)
200163
de