Improving system performance

This group of topics presents information on how to improve the performance of your system. In general, techniques for improving performance are designed to reduce unnecessary processing, network traffic, and blocking.

The techniques minimize these factors:

  • The number of unneeded records stored in tables
  • The number of records retrieved in queries
  • The number of locks on records in queries
  • The duration of locks on records
  • The size and duration of transactions
  • The fragmentation of tables and indexes
  • Timeouts
  • The number of user authorizations required by inbound BOD transactions
Note: Many topics in this group of topics apply only to on-premises environments. These are the sections that also apply to cloud environments: