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
9 replies
Subscribers
7 subscribers
Views
3400 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Hello, We are on Portal and moving to Tempo and would like some feedb
mjmallet
over 8 years ago
Hello,
We are on Portal and moving to Tempo and would like some feedback on databases and what other organizations are doing.
Is it better to have one dedicated database per process? Or to have one database for multiple processes?
Or maybe have one database for the "low records" processes and dedicated database for the "higher records" processes?
Thanks
MJ
OriginalPostID-166601
OriginalPostID-166601
Discussion posts and replies are publicly visible
Parents
0
peterf
over 8 years ago
Agreed that size is not likely to be a driver. For us the issues are external reporting on the application schema, security, portability and maintenance. Questions like does the app support multiple LOBs or just one are likely to come into play.Of course this discussion is predicated on the schema being "owned" by the Appian application. We have applications that also connect to data stores that are owned by other applications and we typically don't park our Appian tables in their schema. As csteward implied, it's a question of figuring out what is right for you business and application portfolio, there is no one size fits all solution.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
peterf
over 8 years ago
Agreed that size is not likely to be a driver. For us the issues are external reporting on the application schema, security, portability and maintenance. Questions like does the app support multiple LOBs or just one are likely to come into play.Of course this discussion is predicated on the schema being "owned" by the Appian application. We have applications that also connect to data stores that are owned by other applications and we typically don't park our Appian tables in their schema. As csteward implied, it's a question of figuring out what is right for you business and application portfolio, there is no one size fits all solution.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data