On Tuesday 31 January 2006 22:27, Timothy Snyder wrote:
>
> For the large file in its dynamic form, is most of the space consumed by
> the dat* or the over* files?
dat files - I know I'm wasting space.
> If the former, you may just be wasting
> space. If the latter, you have some file configuration issues to resolve.
> What does GROUP.STAT show you? Are the records distributed evenly in the
> groups or does it vary greatly?
The distribution is fairly consistent.
> What do your key lengths look like? Are they large or small? Do they
> vary greatly from one record to the next?
They're all similar - about 20-22 characters in length, a mix of alphanumeric.
> You may want to consider using
> the KEYDATA option. It doesn't usually work better than KEYONLY, but I
> have seen it make a huge positive difference on a small percentage of
> files.
>
> You might also want to play around with changing the hash type. 0 usually
> works best, but once in a while 1 will help you. Also, you may actually
> see things improve by increasing the split and merge loads. I've seen
> files that worked with 90/45, but that doesn't happen very often. So much
> depends on the characteristics of the data in the file.
Thanks for your comments
--
Jeff Butera, Ph.D.
Administrative Systems
Hampshire College
[EMAIL PROTECTED]
413-559-5556
"Hindsight alone is not wisdom."
George W. Bush
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
