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
4 replies
Subscribers
5 subscribers
Views
1801 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Integrations
is there a limit on # connections Appian (v 7.3) can make with database ? if so,
bragadeeshp
over 9 years ago
is there a limit on # connections Appian (v 7.3) can make with database ? if so, where can I find the configuration ? Thanks...
OriginalPostID-133093
OriginalPostID-133093
Discussion posts and replies are publicly visible
Parents
0
Aleksi White
Appian Employee
over 9 years ago
I'm not entirely sure on how it would work in that situation, but my assumption would be the following:
If 1000 transactions need to be made, and each transaction needs its own connection, then all the available connections for the database will be used. The remaining transactions will wait until an active transaction completes and frees up the connection, which it will then use. If all these are running at once then that might cause a backup and performance degradation as all these pending transactions are trying to use the database at once.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Aleksi White
Appian Employee
over 9 years ago
I'm not entirely sure on how it would work in that situation, but my assumption would be the following:
If 1000 transactions need to be made, and each transaction needs its own connection, then all the available connections for the database will be used. The remaining transactions will wait until an active transaction completes and frees up the connection, which it will then use. If all these are running at once then that might cause a backup and performance degradation as all these pending transactions are trying to use the database at once.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data