Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
6 replies
Subscribers
7 subscribers
Views
2715 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Administration
Hi All, We need to increase our DB connection limit to 1000. How is i
rishub356
over 9 years ago
Hi All,
We need to increase our DB connection limit to 1000. How is it going to impact our performance? If yes, will it be run time impact only or overall impact?
OriginalPostID-201022
OriginalPostID-201022
Discussion posts and replies are publicly visible
0
Tejas Kargutkar
Appian Employee
over 9 years ago
Which property would you be modifying to implement this change ?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rishub356
over 9 years ago
Connection pool limit
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rishub356
over 9 years ago
i.e. min-pool-size and max-pool-size
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Tim
Certified Lead Developer
over 9 years ago
That sounds like an incredibly high number for the max-pool-size setting. Can you add some detail as to why you think it's necessary?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rishub356
over 9 years ago
We may have high number of users in our Applications & it may touch this limit for DB connections easily.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Tejas Kargutkar
Appian Employee
over 9 years ago
This seems high from the usual default. We might need to check on the db side if there are processes using up connections and not letting it go for a prolonged time instead of increasing the pool limit.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel