🎁 New User? Get 20% off your first purchase with code NEWUSER20 · ⚡ Instant download · 🔒 Secure checkout Register Now →
Menu

Categories

Databases Intermediate

What is Connection Pool?

A cache of database connections that can be reused, avoiding the overhead of creating new connections for each request.

Connection pooling maintains a set of open database connections that are shared among application threads. Creating a new database connection is expensive (authentication, SSL handshake, memory allocation), so pooling dramatically improves performance.

Popular connection poolers include PgBouncer (PostgreSQL), MySQL Connector pools, and application-level pools. Key settings include minimum/maximum pool size, connection timeout, and idle timeout.

Related Terms

Redis
An open-source, in-memory data store used as a database, cache, message broker, and queue with sub-millisecond response times.
Write-Ahead Log (WAL)
A technique where changes are first written to a log before being applied to the database, ensuring crash recovery and data integrity.
Stored Procedure
A precompiled collection of SQL statements stored in the database that can be executed as a single unit.
Materialized View
A database object that stores the precomputed result of a query, offering faster reads at the cost of periodic refresh.
Full-Text Search
A technique for searching natural language text in databases using word stemming, ranking, and relevance scoring.
Transaction
A sequence of database operations that are treated as a single unit — either all succeed or all are rolled back.
 View All Databases Terms →