I’ve seen problems when this value is set too low. Is there a rationale for estimating the correct value? Is there a downside of setting it too high? Thanks.
if you use long transactions that number must be pretty high.
Almost as high as the max concurrent users that will connect on your server.
Better is to keep the transactions are small as possible.
Not taking transactions into account that number doesn’t have to be that high, it depends on how much database time a client will take on average usage.
so how long the queries take and how many a client does in a certain amount of time, you can check the performance tab for this.
It doesnt matter to much if you have that on a high value. The bottleneck will just be moved to the database completely if you have 1000 of connections open and active at the same time…
but having 50 or so there is not a big problem, i would just keep the idle a bit lower (lets say 10 or something) so that spikes can be handled by the max active but normal use
can constantly take some out of the pool.