Version 4.2.5
 —  Database Management System Interfaces  —

Performance Considerations

This section lists some special considerations which may help you increase the performance of your Natural for DL/I environment.


Parameters

Set the DLISIZE parameter to 0 if no DL/I database is to be accessed.

Do not modify NDLPARM parameters, unless requested by a corresponding Natural for DL/I error message. Unused buffers are compressed by the Natural compression algorithm.

DBID

Use the same DBID for all segment types (DDMs) of a given NDB, because an OPEN command is generated for each DBID.

Top of page

Global and Local Data Areas

Keep global and local data areas as small as possible, because the format buffer contains all fields of the global and local data areas, not only those which are referenced by a Natural I/O statement.

Top of page

FIND Statements

If the sequence field is unique, use a FIND(1) statement instead of a FIND statement to prevent an unnecessary second DL/I call.

Top of page

Direct Access to Lower Levels

Access segments on lower levels directly (by using the field sequence of the parent); that is, access ancestor segments only if their contents are required by the application program.

In such cases, UDFs of ancestor segments as well as DL/I fields of ancestor segments which are not sequence fields are not available to the application program.

Top of page

DBLOG Utility

Use the Natural utility DBLOG utility ("TEST DBLOG D") to tune your application; see Logging Database Calls (DBLOG) in the Natural Utilities documentation.

Top of page