Network Guidelines

Remote database access is faster when you send BULK requests to the remote DBEnvironment. For example, if you use the simple FETCH statement on a cursor opened on a remote database, the network must process each successive FETCH as a separate request for data. But if you use BULK FETCH, you make only one request, for a larger number of rows. In your application, use a buffer size that is close to the size of the actual data retrieved.

Use stored procedures to reduce network traffic between applications and the DBEnvironment. Refer to the section "Using Rules and Procedures" in the chapter "Guidelines for Transaction Design."