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
7 replies
Subscribers
8 subscribers
Views
2926 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Having views in DB vs Data manipulation in Expression rules - What approach is best in terms of Performance?
Rama Thummala
Certified Lead Developer
over 7 years ago
Consider simple scenario: I have joining date of an employee in DB, want to find out experience. We can achieve in two ways : 1. Writing a view with DB specific functions to find the date difference 2. Manipulating in Expression rules using Appian functions.
Which approach is best practice/improves performance? and strictly speaking When to go for DB views?
Any suggestions?..
OriginalPostID-241280
Discussion posts and replies are publicly visible
Parents
0
rodgraham
Certified Lead Developer
over 7 years ago
I'd typically use views when joining data from multiple tables or when there's a lot of manipulation required. Not convinced a view is necessary in the example you've given
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
rodgraham
Certified Lead Developer
over 7 years ago
I'd typically use views when joining data from multiple tables or when there's a lot of manipulation required. Not convinced a view is necessary in the example you've given
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data