Performance

 

No matter what kind of application programs you are running on a system, performance can always be a concern. For a distributed relational database, network, system, and application performance are all crucial.

System performance can be affected by the size and organization of main and auxiliary storage. There can also be performance gains if you know the strengths and weaknesses of SQL programs.

• Improving distributed relational database performance through the network
  You can improve the performance of your network in various ways.

• Improving distributed relational database performance through the system
  Achieving efficient system performance requires a proper balance among system resources. Overusing any resource adversely affects performance. This topic describes the commands that are available to help you observe the performance of your system.

• Improving distributed relational database performance through the database
  Distributed relational database performance is affected by the overall design of the database. The location of distributed data, the level of commitment control you use, and the design of your SQL indexes all affect performance.

 

Parent topic:

Distributed database programming

 

Related concepts

Troubleshooting