yes, reorganizing by KEYFILE should speed up performance on the database
a bit when using that keyfile to access the file, but it dramatically
increases the time it takes to reorganize the file.  On a magnitude of
4 or 5 times I seem to recall last time I tested that (I could be wrong
on those figures, so don't quote me, or if you do quote me, say you heard
it from someone else <grin>)

Regards,

Jim Langston

Subject: Re: EDTOBJAUT in CL program?
To: midrange-l@midrange.com
From: rob@dekko.com
Date: Wed, 17 Oct 2001 12:15:05 -0500
Reply-To: midrange-l@midrange.com


Don't see it a whole lot in the industry but one of the things I like about
reorgs is the KEYFILE parameter.  Then I can do a DSPPFM and see the file
in a sorted order.  Hey, KEYFILE's gotta help performance too, shouldn't
it?

Rob Berendt



This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.