|
Booth, can't use the cycle - I'm reading the 2 million records strait from the IFS, in CSV form. I'm loading my lookup table from a physical, and since i have to sorta anyway, i'm reading it sequentially - but that's only a thousand reads or so, so I don't think that's going to make a big difference in the 2mil ifs reads scheme of things. btw, i am one of those heretics who still uses the cycle, level breaks and on rare occasions, (horrors!!!) matching records!. if it works, don't rewrite it ;) Rick -------original message--------- I am curious if removing the K from the F-spec would make a difference i performance that is more noticeable than a faster %Lookup? (I won't even mention using Matching records and Primary/secondary.)
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.