Browse Teach Curate

A Transaction Holds Its Connection for Its Entire Duration

This is spine step five, resting on the finite connection limit and the pool nodes in the database sub-domain, and it is the node that gives the sub-domain a number rather than an intuition. It is the reason the open-across-an-external-call node is an outage rather than a style complaint, and it is what makes the cost of holding a row lock measurable.

Questions this Concept answers

Why does a pooler that multiplexes clients per transaction stop multiplexing when a transaction stays open?

jeremy Video

Borrowing and Returning Database Connections from a Connection Pool and Pool Exhaustion

A connection pool is a managed collection of already-established, reusable database connections that requests borrow and return rather than create and destroy, because establishing a connection carri…