Qus:    How Should I Organise Connection Pools?
Nov 18, 2020 11:53 1 Answers Views: 366 SAI
Prev Next
Answers (1)
PADMAKEECHU Nov 20, 2020 10:58
Answer:   If you have adapter notifications and adapter services then you will need to have two separate connections. Otherwise you may get strange errors about transactions and the like. You should also avoid having connection pools shared across different functional areas, even if they are pointing to the same database. The reason for this is that tuning the size of the pool becomes quite difficult if you have multiple types of usage of a pool. You are also unable to easily change the database settings for one without impacting on the other.
One approach that seems to work quite well is to have separate pools for each package , as your packages should generally be divided up according to functional area too.

Post Your Answer
Guest User

Not sure what course is right for you?

Choose the right course for you.
Get the help of our experts and find a course that best suits your needs.

Let`s Connect