Load Testing · Senior · Question 16 of 76
A service gets more DB connections in its pool, and latency gets worse. Why?
- 1Connection pools can't be larger than the number of servers
- 2The DB is saturated, so more connections add contention and switching
- 3More connections always make each query use more memory
Show the answer
Correct answer: The DB is saturated, so more connections add contention and switching
Explanation
A DB has limited cores and disks. Past a point, extra concurrent queries just wait on locks and CPU. A smaller pool with a queue in the app is often faster.