How to reduce latency with Connection Pools

In this lecture, we will be introducing connection pools. We'll explain what a connection pool is, and why it is important. We'll discuss how connection pools can be used to create a more "predictable" amount of load when compared to some alternative approaches.

00:00 Introduction
00:11 How to connect a database to a driver
00:58 What is the cost of connection pooling?
1:33 How to handle spikes in loading
2:17 How to reduce latency with Connection Pools
2:44 How to reuse connection pools
3:11 How to limit connection pools

#cockroachdb #distributedsql #ConnectionPools #developer

Related Connection Pool content:

[EducationAllTheTime]

Bro, what should be the pool.max value for a project where 15, 000 people log in and spend 20 minutes every day for the SQL connection pool? If pool.max is high but there is not that much usage, could it cause terrible things for the server?

[umardev]

let me ask
let say we have 4 nodes and each node has limit connection about 100 concurrent connection
then we pool connection to node 1 and exceed per node limits

the question is does if node 1 exceeds limit connection then it will distribute/balancing that connection to available node?