RE: lookups and performance

["Bob cozzi" <cozzi@xxxxxxxxx>]

You know, if you've got something that big, why not consider writing out to
a User Index and doing a "find"? That's got to be faster than a look
up--even with 2 million entries. Maybe, maybe not.

Bob Cozzi
Cozzi Consulting
www.rpgiv.com


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Richard B Baird
Sent: Friday, June 20, 2003 12:25 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: lookups and performance


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.