Ways to reduce network traffic

The key to improving performance in a network computing environment is to minimize network traffic.

Stored procedures are an excellent method for sending many SQL statements in a single network message and, as a result, running many SQL statements at the DB2® server. This topic introduces you to other ways to improve performance when accessing remote servers.

Improvements in query efficiency
Queries almost always execute faster on a local server than they do when the same query is sent to a remote server. To increase efficiency when accessing remote servers, try to write queries that send few messages over the network.
Reduction in the volume of messages
DB2 capabilities that combine multiple rows of data during fetch and insert operations can significantly reduce the number of messages that are sent across the network. Those capabilities include block fetch and rowset fetches and inserts.
Optimization for large and small result sets
Several options on the SELECT statement let you limit the number of rows that are returned to a client program.

Parent topic: Distributed data access