|
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 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.