posted 14 years ago
I think it's unlikely that all 200 users will access the web app in a way so that 200 connections will be open at the same time. While it's a possibility (and obviously depends on the application), I'd say that a pool of size 50 should be plenty big enough to serve 200 simultaneous users.
Most likely, I wouldn't make the pool bigger than 50 (rather smaller), because the DB is not going to be particularly responsive it if has to handle 50 queries at the exact same time.