jump to navigation

Connection Pool September 21, 2007

Posted by essamabdelaziz in DataBase.
trackback

Connection Pool

connection pool

A set of connections maintained so that the connections can be reused when there is a future need for the conneciton.

Connection pools are used to reduce the overhead of using a database. Establishing a connection to the database is a costly operation. A connection pool keeps a pool of open connections, each connection can be used for a time as needed, and then released back to the pool. A connection that has been released back to the pool can then be reused.

Connection pooling is especially important in server applications. The overhead of opening a new connection for each new client request is too costly. Instead, the database pool allows for a connection to be opened once and then reused for many requests.

DataSource

DataSource

A JDBC term (and interface name) used for a factory that is used to obtain connections.

Comments»

No comments yet — be the first.