Database connection: Difference between revisions

Revision as of 03:36, 19 December 2020

Revision as of 22:16, 4 August 2021

Line 9:

== Pooling ==

Database connections are finite and [[time complexity|expensive]] and can take a disproportionately long time to create relative to the operations performed on them. It is very inefficient for an application to create, use, and close a database connection whenever it needs to update a database.

[[Connection pool]]ing is a technique designed to alleviate this problem. A pool of database connections can be created and then shared among the applications that need to access the database.