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?..

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