What is a Connection Pool?

A connection pool is a store of database connections that can be used and (most importantly) re-used to connect to a database.

Rather than creating a new connection each time one is needed a pool of connections is created when your application server is started. These connections can then be used and re-used. When a new connection is required the pool is searched for an available connection. If one is available it is returned to the requester. If one is not available then the request is either queued or a new connection is established depending on how many connections are already in the pool and how the pool is configured. Once the connection is finished with, rather than closing it the connection is returned to the connection pool for use by the next requester.

Featured Post

Need copyright-safe songs?

When choosing music for your next video, you can avoid copyright-related issues by picking a song from the YouTube Audio Library.