- Declare index vs. exposing columns
- Keyed data page
- Virtual list copy
- Parallel connectors/Load data page async
- Simple condition as first condition in AND or OR
- Appropriate scope for Data pages.
- Reload per interaction
- Refresh strategy for node level datapage
- 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