HP 3000 Manuals

ALLBASE/SQL Performance 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 single
       request for data.  If you use BULK FETCH, there is only a single
       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 "Guidelines for Transaction Design"
       chapter.

MPE/iX 5.0 Documentation