HP 3000 Manuals HP 3000 Manuals
At a Glance
For every report produced with HP ALLBASE/BRW, report execution
performance is influenced by the following basic factors:
* the amount of data to be printed in the report
* the amount of data in the datasets, files or HP SQL tables
accessed by the report
* how data from datasets, files or HP ALLBASE/SQL tables is combined
(joined or merged)
* calculations and formatting performed during report execution
In addition to these basic factors, you can affect execution performance
in other ways without impairing the original reporting requirements.
To improve performance, you can do the following:
* Reduce the amount of data to the subset needed for printing in the
report, as early as possible.
* Reduce the number of physical block transfers from and to the
disks.
* Reduce the number of head movements on the disks; that is, provide
an efficient access profile on the disks.
This chapter covers
* influencing performance
* data access methods
* using the compile listing
* execution statistics
* effective calculations
* table calculated items vs layout calculated items