HP 3000 Manuals

ALLBASE/SQL Performance Guidelines

ALLBASE/SQL 
Performance Guidelines 

Printed in U.S.A.
Customer Order No.  36389-90001

________________________________________________________________________
|The information contained in this document is subject to change       |
|without notice.                                                       |
|                                                                      |
|HEWLETT-PACKARD MAKES NO WARRANTY OF ANY KIND WITH REGARD TO THIS     |
|MATERIAL, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF    |
|MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. Hewlett-Packard |
|shall not be liable for errors contained herein or for incidental or  |
|consequential damages in connection with the furnishing, performance, |
|or use of this material.                                              |
|                                                                      |
|Hewlett-Packard assumes no responsibility for the use or reliability  |
|of its software on equipment that is not furnished by Hewlett-Packard.|
|                                                                      |
|This document contains proprietary information which is protected by  |
|copyright.  All rights are reserved.  No part of this document may be |
|photocopied, reproduced, or translated to another language without the|
|prior written consent of Hewlett-Packard Comp any.                    |
________________________________________________________________________

          Copyright (c) 1989, 1992 by Hewlett-Packard Company 
Printed November 1992

Print History 

The following table lists the printings of this document, together with
the respective release dates for each edition.  The software version
indicates the version of the software product at the time this document
was issued.  Many product releases do not require changes to the
document.  Therefore, do not expect a one-to-one correspondence between
product releases and document editions.

Edition           Date                      Software Version 
---------------------------------------------------------------------------------------
First             December 1989             ALLBASE/SQL Release D
Second            November 1992             ALLBASE/SQL Release F


NOTE  The F release of ALLBASE/SQL for use with HP-UX (36217-02A.F0.00)
      is compatible with the 8.0 and 9.0 releases of the HP-UX operating
      system.  The F release of ALLBASE/SQL for use with MPE/iX
      (36216-02A.F0.00) is compatible with the 4.0 release of the MPE/iX
      operating system.



            


            

Preface 

This document presents a series of guidelines for use in tuning the
performance of your ALLBASE/SQL F.0 system.  These guidelines are
applicable for the MPE/iX 4.0 release and for the HP-UX 8.0 and 9.0
releases.  Chapters are as follows:

   *   "Basic Concepts in ALLBASE/SQL Performance" describes some
       internal concepts in very basic terms to make understanding the
       guidelines easier.
   *   "Guidelines on Logical and Physical Design" describes the
       performance implications of database design and file storage for
       user tables and indexes.
   *   "Guidelines on Query Design" shows how to build queries that are
       most likely to use indexed access.
   *   "Guidelines on Transaction Design" describes techniques for
       avoiding conflicts among transactions to obtain the greatest
       concurrency.
   *   "Guidelines on System Administration" presents techniques for
       improving performance in the following areas:
          *   DBA Guidelines
          *   Network Guidelines
          *   HP-UX Guidelines
          *   MPE/iX Guidelines
   *   An appendix, "Design for a High-Performance Table Editor,"
       sketches an approach to table editing that avoids concurrency
       problems and promotes high performance through the use of BULK
       operations.

Additional basic information relating to performance is found in the
following chapters in the ALLBASE/SQL document set:

   *   "Logical Design" and "Physical Design" in the ALLBASE/SQL Database 
       Administration Guide.
   *   "Concurrency Control" in the ALLBASE/SQL Reference Manual.
   *   "Transaction Management with Multiple DBEnvironment Connections"
       in the ALLBASE/SQL Release F.0 Application Programming Bulletin.
   *   "Processing with Cursors" in the ALLBASE/SQL application
       programming guide for your programming language.

MPE/iX 5.0 Documentation