Nothing really -  less than 10% overflow is not too bad.
I would have chosen a smaller block size though.

On 20/06/2012 17:20, Dave Laansma wrote:
I have my thoughts already in place but I'd like to hear input on this.
What is wrong with this file?



File name(Dynamic File)               = OHL

Number of groups in file (modulo)     = 740972

Dynamic hashing, hash type            = 0

Split/Merge type                      = KEYONLY

Block size                            = 4096

File has 455028 groups in level one overflow.

Number of records                     = 4835502

Total number of bytes                 = 3100999567



Average number of records per group   = 6.5

Standard deviation from average       = 2.4

Average number of bytes per group     = 4185.0

Standard deviation from average       = 1856.2



Average number of bytes in a record   = 641.3

Average number of bytes in record ID  = 14.8

Standard deviation from average       = 283.6

Minimum number of bytes in a record   = 133

Maximum number of bytes in a record   = 8622



Minimum number of fields in a record  = 110

Maximum number of fields in a record  = 334

Average number of fields per record   = 218.3

Standard deviation from average       = 47.9

File has 2 over files, 3 prime files



Sincerely,

David Laansma

IT Manager

Hubbard Supply Co.

Direct: 810-342-7143

Office: 810-234-8681

Fax: 810-234-6142

www.hubbardsupply.com<http://www.hubbardsupply.com>

"Delivering Products, Services and Innovative Solutions"



_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to