Jim Phillips wrote:
> So, I ran Howmessy on the main data base here and the very first data set looks very suspicious.  The report for this manual master shows 78% full (19381 entries, 24859 capacity), 30.3% secondaries, maximum blocks=190, blocking factor=1, maximum chain=7, average chain=1.43, standard deviation=.70, expanded blocks=1.43, average blocks=2.30, elongation=1.60 and, are you ready for this, inefficient pointers=100%!
>    
>   My first thought was to increase the blocking factor (my thinking is with a blocking factor of 1, every pointer must cross a block boundary).  I could also increase the capacity somewhat to get the load factor down to 70% or so.
>    
>   What does this august group recommend?
>    
>  

Unless you think that you are going to add another 2k entries in the 
near future, I would not advise doing anything.
Howmessy has not been updated for MPE/iX. The statistics you are looking 
at for a master data set are nearly meaningless.

Beechglen has a free utility DBLOADSX,   This program provides fast 
native-mode analysis for complete databases or individual datasets.
The lattest version also reports DDX, MDX, and Btree information.  
http://beechglen.com/mpe/dbloadsx.html

TGIF,

Mike Hornsby
CTO/CoFounder
Beechglen Development Inc.
513-922-0509 x31

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *