Hi how do i figure about how many connection to to set my max at.

Right now I'm getting Failed to checkout connection at a pool size of 200.

Trying to stress test my app at 40 users a second. The DB is definitely a bottle neck as the more workload the longer each "request" takes which I assume i what is causing the connection checkout to fail.

Basically this app is a "direct" translation of a windows ADO app. ADO seems to open a connection per request which doesn't cause to lose the request only make it slower. Here I lose a request, because I don't have enough connections in the data source to acquire.

I figure I can set a "high" max pool size to "mimic" ADO, knowing that the pool will readjust itself on lower loads. Or maybe set a higher check out timeout?