HP 3000 Manuals

ALLBASE/SQL Performance and Monitoring Guidelines

Chapter 4  Guidelines on Transaction Design 

Transaction design is important for performance because it determines the
type and duration of locks held by your applications.  By selecting
appropriate lock types, and by avoiding unnecessary locking, you can
improve performance.  Topics in this chapter include the following:

   *   General Tips on Managing Transactions.
   *   Controlling Locking.
   *   Using Isolation Levels.
   *   Using Row Level Locking.
   *   Using KEEP CURSOR.
   *   Removing Non-Database Processing.
   *   Using Procedures and Rules.
   *   Tuning Performance of Dynamic Statements.

MPE/iX 5.0 Documentation