it would help to have some specific information about your file - such as -
what is the split/merge type?
Here you go Wally. :)
Number of groups in file (modulo) = 4766568
Minimum groups of file = 1192027
Hash type = 0, blocksize = 1024
Split load = 20, Merge load = 10
Split/Merge type = KEYONLY
AR.INVOICE.ITEMS
Basic statistics:
File type............................... Dynamic Hashing
File size
[dat001].............................. 1073741824
[dat002].............................. 1073741824
[dat003].............................. 1073741824
[dat004].............................. 1073741824
[dat005].............................. 586003456
[over001]............................. 1073741824
[over002]............................. 1073741824
[over003]............................. 1073741824
[over004]............................. 1004517376
File modulo............................. 4766568
File minimum modulo..................... 1192027
File split factor....................... 20
File merge factor....................... 10
File hash type.......................... 0
File block size......................... 1024
Group count:
Number of level 1 overflow groups....... 4126698
Primary groups in level 1 overflow...... 4004970
Primary groups over split factor........ 1321
Record count:
Total number of records................. 33011808
Average number of records per group..... 6.93
Standard deviation from average......... 1.25
Minimum number of records per group..... 0
Maximum number of records per group..... 17
Median number of records per group...... 8.50
Record length:
Average record length................... 18.09
Standard deviation from average......... 147.94
Minimum record length................... 46
Maximum record length................... 947
Median record length.................... 496.50
Key length:
Average key length...................... 7.73
Standard deviation from average......... 0.50
Minimum key length...................... 1
Maximum key length...................... 8
Median key length....................... 4.50
Data size:
Average data size....................... 35.82
Standard deviation from average......... 162.80
Total data size......................... 1182429533
Minimum data size....................... 63
Maximum data size....................... 965
Median data size........................ 514.00
Data in 1 - 512 bytes range............. 33011793 (100.00%)
Data in 513 - 1024 bytes range.......... 15 (0.00%)
Largest data size:
965 bytes of data for this key.......... "16696429"
848 bytes of data for this key.......... "16707774"
817 bytes of data for this key.......... "36564096"
Smallest data size:
63 bytes of data for this key........... "1363268"
63 bytes of data for this key........... "1363269"
63 bytes of data for this key........... "1363270"
Predicted optimal size:
Records per block....................... 10
Percentage of near term growth.......... 10
Scalar applied to calculation........... 0.00
Block size.............................. 1024
Modulo.................................. 4766568
Files processed: 1
Errors encountered: 0
Jeff Butera, Ph.D.
Administrative Systems
Hampshire College
[EMAIL PROTECTED]
413-559-5556
"Daddy - did you lose your mind?"
Catherine Butera
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
