Best Practices to improve performance of each appian object

Start here: https://docs.appian.com/suite/help/21.4/Performance_View.html

Identify the parts taking too long.

The bets practices are the same in any language:

• only get the data you need to get for the context you're in
  • don't get more data than you need to display/process
• limit the amount of data retrieved from the data source
  • retrieve your data in small batches if possible
• minimize the number of round trips to the database to fetch the data
  • for example, if you have a value in the database that requires decoding, don't make one call to the database for each row you've retrieved - retrieve the list of decodes as a a second call and decode locally in the user interface 

I'm sure there are other best practices that I've neglected to mention that others can throw into the discussion...

Yup, will go through it,

Thanks:)

Hi,

1. Especially for the looping functions... need to modify. If you are using IF() or nested IF conditions for multiple if ... try to change it to Choose() function.

2. Make sure, you are not hitting the DB multiple times in Interface, Expression rules or other objects.

3. Use Paging and filtering on record. Do not load all the items in one go.

4. Do not create any unnecessary groups, expression rules, interfaces or other objects which are not used in your application.

Will add more if I found... thank you.

In addition to what others have mentioned, also check any security checks. If you have any display areas that is pulling back all members of a group (as they are always larger than in non-prod) and checking security.

Null handling is important.