What aspects of the definition of one-to-one relationships in a Subset have an effect on performance?
Most of the factors affecting performance, at least in Subset design, are connected with the definition of one-to-many relationships or the use of OPNQRYF. The main performance-related factor in the definition of one-to-one relationships is the choice of parameters controlling OPEN/DB’s use of “in-core” logic. Choosing in-core logic instructs OPEN/DB to generate code that will retain the last n used records in program variables, and retrieve the required record from the program variables if possible. By default, this option is selected for every one-to-one relationship that you define, and the default value of n is 20. In the majority of cases, this option considerably speeds up data retrieval by reducing the disk I/O that a report needs to perform. In most cases, it will be sufficient to accept the defaults that OPEN/DB proposes. Only in a couple of situations might you wish to vary from the defaults, and you should consider carefully before doing so to ensure that your changes will h
Related Questions
- What is the correct definition of Free Cash Flow and is it useful to compare a companys performance from one year to the next, on the basis of Free Cash Flow and the way it changes?
- What is the difference between the social performance framework, the definition, and the tools and methodologies in the resource center?
- What is the definition of a "Dysfunctional" family?
