Database Optimization

A number of techniques, unique to PSL, have a significant impact on the run-time performance of a program. The following performance techniques will improve run-time under every operating system and database scenario without tradeoffs (with the possible exception of caching under an M database).

For additional details concerning database optimization, refer to the following sections:

ClassNew Parameter

Preference of Record<class>.bypassSave

Selecting Data

Use of the #IF/#ELSE and Literal Scope Variables

Use of the #WHILE Compiler Command

Use of the Cache Class

Use of the Qualifiers with Db.insert and Db.update

Refer to the Selecting Data section for guidelines when selecting data from the database.