Pradeep Gunda (PradeepG0495)
NJ Courts

NJ Courts
PradeepG0495 Member since 2017 11 posts
NJ Courts
Posted: July 27, 2017
Last activity: August 28, 2017
Posted: 27 Jul 2017 15:27 EDT
Last activity: 28 Aug 2017 12:20 EDT

Concurrent Thread Pool size vs DB Cconnection Pool


We have 600K input records in a pega table, and for each record we need to creat a Work Object. Each work object takes over 30 seconds to be created, as we have a lot of integration.

We will have to have around 200 standard agents in order for us to complete this whole process in a day or so.

For testing I just have created 20 standard agents, and updated the thread pool size in app server to 20. These 20 agents were running simultaneously but the application has become very slow, and other OOTB agents were getting the DB Connection exceptions. I got the DB Connection pooling also increased to 40 and the application seems to be a bit stable now.

Is there any ratio or some sort of relation between the Thread pool size and the DB connections, how to decide on the max value for these resources.

I want to be able to initiate 200 standard agents in PROD and be able to access the application with out much delay/lag.

Your ideas are appreciated!



Data Integration Java and Activities
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.