|
My first thought is simple: If you are processing all the records anyway, then you just discovered one of the best ways to improve performance. --------------------------------- Booth Martin http://www.martinvt.com --------------------------------- -------Original Message------- From: Midrange Systems Technical Discussion Date: 11/03/05 12:07:26 To: MIDRANGE-L@xxxxxxxxxxxx Subject: Reading keyed file sequentially FWIW, I'm at V5R2. I have a "transaction-type" file that is keyed on company (10A) and date(D). Each day records are added for lots of companies. When browsing the PF, I was not surprised to see records not in the order specified by the key but in arrival order. However, I wrote a program to read this file sequentially and it read it that way too - not in keyed order. I know I could reorg the file before running the program to put the records in the order specified by the key. I also know I could create an LF and have the program read it. Because the file is really big (+20 million records) I did neither since I thought the reorg would run too long and the overhead of maintaining an LF would be too great. Thoughts? TIA. Jim Newman -- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l. .
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.