Connection pooling
A pattern used with storing already precreated connections to a db, which can be used when talking to a database instead of connecting anew to a database.
Similar to the pattern of object pooling
Benefits
speed, faster to use already created connections rather than alway creating new connections
Libraries
Java
HikariCP
C3po
Improving
More threads only perform better when blocking creates opportunities for executing.
As blocking because of waiting for IO to execute (thus more threads is better for old HDD rather than SSD)
More threads than CPUs means context switching, due to time slicing, is slower than one thread per cpu
You want a small pool, saturated with threads waiting for connections.
https://github.com/brettwooldridge/HikariCP/wiki/About-Pool-Sizing
Last updated