Is a good practice to share the same DBCPConnectionPool between several process groups or it is better to have one DBCPConnectionPool assigned to each process group?
I currently have 16 process groups that share the same DBCPConnectionPool which is at root level. There are 41 processors that are referencing that DBCPConnectionPool.
If it is a good practice, what is the recommended configuration so that performance is not affected?
I currently have it configured this way:
Max Wait Time: 500 millis.
Max Total Connections: -1
Minimum Idle Connections: 0
Max Idle Connections: 8
Max Connection Lifetime: -1
Time Between Eviction Runs: -1
Minimum Evictable Idle Time: 30 mins
Soft Minimum Evictable Idle Time: -1
Thanks in advance!