3 ms·
The other half of this is correctly using the connection pool in the application layer to begin with. One of the most common performance errors I see in random
by wild_preference 8y ago
The other half of this is correctly using the connection pool in the application layer to begin with.
One of the most common performance errors I see in random http applications is grabbing db connections for too long, like in middleware, or too aggressively in parallel queries.
- sb8244 8y agoThis is so true and easy to overlook until a post mortem. A great exercise is to audit how connections are maintained in your application, before it's too late.
- macintux 8y agoI'm reminded of a systems failure described in, IIRC, the O'Reilly book "Release It!". Java ODBC exception swallowed resulted in eventually running out of connections. Very tough problem to troubleshoot without extensive monitoring.
- fnord123 8y agoRelease it! is Prag Press. Good book too!