Re: lookups and performance

["Pete Clifford" <Pete@xxxxxxxxxxxxxxxxxxxxx>]

"Richard B Baird" <rbaird@xxxxxxxxxxxxxxxxxxxxx>
wrote in message
news:OF1ED7B429.2A83BE6B-ON05256D4B.005FAC92-05256D4B.005FAD76@xxxxxxxxxxxxxxxxxxxxxxxx
>
> 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.)
>
>
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>