[RFC] How many SQL connections in your pool

[Peter Schober]

* Chad La Joie <lajoie at itumi.biz> [2012-02-06 19:46]:
> For those that use SQL connection pooling in your IdP data connector,
> what is the maximum number of connections you allow to your database
> (i.e., what is your poolMaxSize)?

My context deployment fragment (container managed connections)
currently has maxActive="10" maxIdle="5" *twice* -- once for ordinary
data connectors and agaon for StoredIds/PersistentIds (the latter have
their own schema in the DB and hence need a seperate DB connection. If
we could specify table names etc. this wouldn't be necessary, I think).

This was without much tuning. IIRC our DBAs are happy as long as < 30
connections are opened.
-peter