Thursday, December 14, 2023

Performance checklist

  1.  Declare index vs. exposing columns
  2. Keyed data page
  3. Virtual list copy
  4. Parallel connectors/Load data page async
  5. Simple condition as first condition in AND or OR
  6. Appropriate scope for Data pages.
  7. Reload per interaction
  8. Refresh strategy for node level datapage
  9. Report definition over obj methods

1) DB Indexes :  Analyze the query plan. Create DB Indexes on the columns that used on the filter conditions of the RD.
2) Avoid reading from Blob : Lookups read the entire blob column, so avoid reading the BLOB. Prefer to use RD's.
3) Background processing : Leverage background processing, wherever the need of processing and the data need not be shown to the user immediately. ( Agents, QueueProcessor, Async activity, load-datapage, Queue method)
4) Keyed data page : Read the data 
5) Node level : Cache the frequently accessed data in-memory.
6) Deferred loading : Configure the deferred loading on the parts of the screen (sections) that they are not interested to see imemediately.

No comments:

Post a Comment