A Connection Pool is a cache of database connections maintained in the database's memory so that the connections can be reused when the database receives future requests for data. Look up cache in Wiktionary, the free dictionary. ... A database is a collection of logically related data designed to meet the information needs of one or more users. ...

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 over 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.... Website - Wikipedia, the free encyclopedia /**/ @import /skins-1. ...

Connection pooling being normally used in web-based and enterprise applications is usually handled by an application server. Any dynamic page can be coded to open a connection and close it normally but behind the scenes when a new connection is requested, one is returned from the connection pool maintained by the application server. Similarly, when a connection is closed it is actually returned to the connection pool.

Connection pooling is not only possible using application servers. Traditional applications that need frequent access to databases can benefit from connection pooling as well. This was traditionally handled by manually maintaining database connections, but as expected, that meant very well-crafted programming as the framework for pooling is highly complex. In recent years, things have become a lot easier due to availablity third-party libraries that allow connection pooling as well as SQL statement pooling, thus giving high performance in database intensive aplications. The best part is that many of these packages such as DBCP and c3p0 are not only free but also open-source, meaning rapid development, easy availability and possibility of tweaking for those demanding complete control over their use.

Various parameters such as number of minimum connections, maximum connections and idle connections can be set to make sure the connection pool works well according to the environment it is deployed to work in.

External links

• Jakarta DBCP Homepage
• c3p0 Homepage