-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of john reid
Sent: Tuesday, October 16, 2007 2:17 PM
To: [email protected]
Subject: Re: [U2] Size of Key Question
and the FILE.STAT?
File name = SALES-HIST-BR1
File type = 18
Number of groups in file (modulo) = 3000017
Separation = 1
Number of records = 883026
Number of physical bytes = 1667799040
Number of data bytes = 150663032
Average number of records per group = 0.2943
Average number of bytes per group = 50.2207
Minimum number of records in a group = 0
Maximum number of records in a group = 7417
Average number of bytes per record = 170.6213
Minimum number of bytes in a record = 64
Maximum number of bytes in a record = 2644
Average number of fields per record = 25.6579
Minimum number of fields per record = 11
Maximum number of fields per record = 41
Groups 25% 50% 75% 100% 125% 150% 175% 200% full
2855826 50132 31541 14753 12862 5383 4611 24909
Press any key to continue...
On 10/16/07, roy <[EMAIL PROTECTED]> wrote:
> Random reads and updates on a file with ~2 million records. I separated
the
> reads and writes to a separate program that only does this processing to
no
> avail.
>
> Topas shows 100% disk usage during this process and all other users are
> affected.
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
