Best Practices to improve performance of each appian object

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

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

Null handling is important.