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.
- Deciding DRDA data location
Because putting a network between an application and the data it needs will probably slow performance, consider these items when deciding where to put data.
- Factors that affect blocking for DRDA
A very important performance factor is whether blocking occurs when data is transferred between the application requester (AR) and the application server (AS). A group of rows transmitted as a block of data requires much less communications overhead than the same data sent one row at a time.
- Factors that affect the size of DRDA query blocks
If a large amount of data is being returned on a query, performance might be improved by increasing the size of the block of query data. How this is done depends on the types of systems participating in the query.
Parent topic:
Performance
Related concepts
Planning and design