HP 3000 Manuals

ALLBASE/SQL Performance Guidelines

Chapter 1  Basic Concepts in ALLBASE/SQL Performance 

Before presenting specific tips and tricks for tuning your
DBEnvironments, this chapter presents some information about how data is
passed about in ALLBASE/SQL among files, buffers, applications, and other
elements in a typical large-scale production environment.  The following
topics are included:

   *   DBEFile organization.
   *   Data Buffering.
   *   System Catalog.
   *   Log File Organization.
   *   Log Buffering.
   *   Locking and Latching.
   *   Sorting.
   *   Optimization.
   *   Sections and Validation.

Before reading on, you may wish to review the material found in the
"Physical Design" chapter of the ALLBASE/SQL Database Administration 
Guide and the "Concurrency Control" chapter of the ALLBASE/SQL Reference 
Manual.

MPE/iX 5.0 Documentation