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 bryant.st39 over 7 years ago

For moving applications with views to different environments, we break our application into smaller applications. The first app contains CDTs, data stores (without views), process models to build views, and groups. Once that application is imported, data stores published, and views created, then we import an application or patch containing a data store with the views. Then we import the rest of the application.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 bryant.st39 over 7 years ago

For moving applications with views to different environments, we break our application into smaller applications. The first app contains CDTs, data stores (without views), process models to build views, and groups. Once that application is imported, data stores published, and views created, then we import an application or patch containing a data store with the views. Then we import the rest of the application.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data