Connection Pooling
DATABASE, CONNECTION, banaна, EXPENSIVE, OPERATION, hai (TCP, HANDSHAKE, AUTHENTICATION) — HAR, QUERY, ke, liye, NAYA, CONNECTION, banaна, PERFORMANCE, ko, KAAFI, HURT, karta hai. Connection, POOL, EK, SET, OF, REUSABLE, CONNECTIONS, MAINTAIN, karta hai.
JAB, EK, QUERY, ZAROORI, hoti hai, POOL, SE, EK, FREE, CONNECTION, "BORROW", ki, jaati hai — QUERY, COMPLETE, hone, ke, baad, CONNECTION, POOL, mein, WAAPAS, RETURN, ho, jaata hai, DESTROY, nahi, hota.
const { Pool } = require("pg");
const pool = new Pool({
connectionString: process.env.DATABASE_URL,
max: 20, // MAXIMUM connections, pool, mein
idleTimeoutMillis: 30000,
});
// Pool, AUTOMATICALLY, connections, MANAGE, karta hai:
app.get("/users", async (req, res) => {
const result = await pool.query("SELECT * FROM users");
res.json(result.rows);
});- Connection pooling = reusable, connections, ka, set, MAINTAIN, karta hai
- Har query ke liye, naya, connection, banaна, EXPENSIVE, hai
- Pool size, TRAFFIC, aur, database, ki, LIMIT, ke, hisaab, se, TUNE, karo
AGAR, SAARE, CONNECTIONS, BUSY, HAIN, aur, POOL, ki, MAX, LIMIT, PAHUNCH, chuki, hai, NAYI, REQUESTS, QUEUE, mein, WAIT, karti, HAIN — connectionTimeoutMillis, se, EK, MAX, WAIT, TIME, SET, kiya, ja, sakta hai, JISKE, BAAD, ERROR, THROW, hoga.
const pool = new Pool({
max: 20,
connectionTimeoutMillis: 5000, // 5 sec wait, phir, error
});HAR, pool.connect() call, ke, BAAD, client.release() CALL, karna, CRITICAL, hai — WARNA, CONNECTION, POOL, mein, WAAPAS, NAHI, aata, aur, EVENTUALLY, POOL, EXHAUST, ho, jaata hai (CONNECTION, LEAK).