HP 3000 Manuals

ALLBASE/SQL Performance and Monitoring Guidelines

Network Guidelines 

If you are using ALLBASE/SQL in a network, you should structure your
applications with remote access in mind.

   *   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."

MPE/iX 5.0 Documentation