HP 3000 Manuals HP 3000 Manuals
Execution Statistics
During report execution, HP ALLBASE/BRW optionally provides statistics on
the amount of time each part of the report needed (CPU and elapsed time),
and how many records have been read, written or sorted.
The following are the associated execution statistics for the compile
listings for Examples 1, 2, and 3.
Example 1: Statistics of Keyed Access
_____________________________________________________________________________________
| |
| |
| Access Block 1: |
| $records cpu-sec elapsed-sec |
| -------- ------- ----------- |
| read-dset serial ORDER-DETAILS, TOYDB 98 0.518 2.201 |
| read-dset calc PRODUCTS, TOYDB 23 0.281 2.864 |
| write WORK001 23 0.282 0.902 |
| sort WORK001 23 1.101 3.932 |
| process 1.432 3.992 |
| ======= ========== |
| time totals for block 3.614 13.891 |
| |
| Access Block 2 |
| $records cpu-sec elapsed-sec |
| -------- ------- ----------- |
| read-mpe serial WORK001 23 0.235 0.325 |
| print PFK 40 0.909 1.425 |
| process 0.830 1.026 |
| ======= ========== |
| time totals for block 1.974 2.776 |
| |
| Report Info : |
| |
| |
| cpu-sec elapsed-sec |
| ======= =========== |
| time totals for report 5.588 16.667 |
| |
| |
_____________________________________________________________________________________
Example 2: Statistics of Serial Access
_____________________________________________________________________________________
| |
| |
| Access Block 1: |
| $records cpu-sec elapsed-sec |
| -------- ------- ----------- |
| read-dset serial PRODUCTS, TOYDB 30 0.279 0.380 |
| write WORK001 30 0.336 0.681 |
| sort WORK001 30 0.942 3.473 |
| process 0.966 1.450 |
| ======= ========== |
| time totals for block 2.523 5.984 |
| |
| Access Block 2 |
| $records cpu-sec elapsed-sec |
| -------- ------- ----------- |
| read-mpe serial ORDER-DETAILS, TOYDB 98 0.500 0.657 |
| write WORK002 23 0.284 0.734 |
| sort WORK002 23 1.065 2.665 |
| process 0.813 0.907 |
| ======= ========== |
| time totals for block 2.662 4.963 |
| |
| Access Block 3 |
| $records cpu-sec elapsed-sec |
| -------- ------- ----------- |
| read-mpe serial WORK001 30 0.265 0.380 |
| read-mpe search WORK002 23 0.358 0.587 |
| write WORK003 23 0.315 0.497 |
| sort WORK003 23 1.150 2.541 |
| process 0.961 0.989 |
| ======= ========== |
| time totals for block 3.049 4.994 |
| |
| Access Block 4 |
| $records cpu-sec elapsed-sec |
| -------- ------- ----------- |
| read-mpe serial WORK003 23 0.235 0.314 |
| print PFS 40 0.867 1.220 |
| process 0.840 0.950 |
| ======= ========== |
| time totals for block 1.942 2.484 |
| |
| |
| Report Info : |
| |
| cpu-sec elapsed-sec |
| ======= =========== |
| time totals for report 10.176 18.425 |
| |
| |
_____________________________________________________________________________________
Example 3: Statistics of HP ALLBASE/SQL Access
_____________________________________________________________________________________
| |
| |
| Access Block 1: |
| |
| #records cpu-sec elapsed-sec |
| |
| --------- --------- ----------- |
| |
| read-sql QUERY 1,EXPLSQL 4 0.686 0.815 |
| |
| read-dset chain ORDERS,EXPLDB 4 0.031 0.039 |
| |
| write WORK001 4 0.079 0.272 |
| |
| process 1.556 3.469 |
| |
| ======= ========== |
| |
| time totals for block 2.352 4.595 |
| |
| (0 segment loads for block) |
| |
| |
| |
| Access Block 2 |
| |
| #records cpu-sec elapsed-sec |
| |
| --------- -------- ----------- |
| |
| read-mpe serial WORK001 4 0.147 0.146 |
| |
| print TESTLIST 4 0.109 0.500 |
| |
| process 0.038 0.038 |
| |
| ======= ========== |
| |
| time totals for block 0.294 0.684 |
| |
| (0 segment loads for block) |
| |
| |
| |
| |
| |
| Report Info : |
| |
| |
| |
| cpu-sec elapsed-sec |
| |
| ======= =========== |
| |
| time totals for report 2.646 5.279 |
| |
| |
| |
| |
_____________________________________________________________________________________