...to add to my previous post, the file uses about 30MB, no indices.
DATA.30 8966144 bytes
OVER.30 21733376 "
ANALYZE.FILE GRTRANS STATS
File name .................. GRTRANS
Pathname ................... GRTRANS
File type .................. DYNAMIC
Hashing Algorithm .......... GENERAL
No. of groups (modulus) .... 4375 current ( minimum 1, 279 empty,3168
overflowed, 2448 badly )
Number of records .......... 10787
Large record size .......... 2054 bytes
Number of large records .... 3523
Group size ................. 2048 bytes
Load factors ............... 80% (split), 50% (merge) and 80% (actual)
Total size ................. 30638080 bytes
Total size of record data .. 24859927 bytes
Total size of record IDs ... 79549 bytes
Unused space ............... 5694508 bytes
Total space for records .... 30633984 bytes
Number per group ( total of 4375 groups )
Average Minimum Maximum StdDev
Group buffers .............. 3.42 1 28 2.81
Records .................... 2.47 1 8 1.42
Large records .............. 0.81 1 5 0.87
Data bytes ................. 5682.27 276 55330 5677.04
Record ID bytes ............ 18.18 1 74 12.09
Unused bytes ............... 1301.60 12 41020 935.90
Total bytes ................ 7002.05 2048 57344 0.00
Number per record ( total of 10787 records )
Average Minimum Maximum StdDev
Data bytes ................. 2304.62 187 49166 3002.46
Record ID bytes ............ 7.37 1 14 3.83
Total bytes ................ 2311.99 188 49180 3004.83
**********************************************************************
This email message and any files transmitted with it are confidential
and intended solely for the use of addressed recipient(s). If you have
received this email in error please notify the Spotless IS Support Centre (61 3 9269
7555) immediately who will advise further action.
This footnote also confirms that this email message has been scanned
for the presence of computer viruses.
**********************************************************************
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
