Tag Info

New answers tagged

2

A lot of applications have poor connection discipline, keeping connections open even when they are not being used. Setting a high connection limit is cheap insurance against these applications. Until something changes and the applications decide to actively use all of those connections, then the insurance becomes pretty expensive.


9

"Can support" != "optimal throughput". You can use lots of connections, but it's slower. If you use fewer connections and queue work, you get the same amount of work done in a smaller time. Even more extreme is the discrepancy for another DBaaS provider, who proposes a 2 core server with 500 concurrent connections. How could this possibly work well? ...



Top 50 recent answers are included