Re: Setll vs. chain

You could preface the program with an OPNQRYF joining your primary file with
the file containing the formula. By default, you will only select the
records that have a match.
-----Original Message-----
From: Jon.Paris@halinfo.it <Jon.Paris@halinfo.it>
To: RPG400-L@midrange.com <RPG400-L@midrange.com>
Date: Wednesday, February 09, 2000 9:28 PM
Subject: Re: Setll vs. chain


>
>
>Carl - I don't know how many records there are in the formula file, or how
big
>they are - but I'd seriously think about loading them into a user space and
>using either a user index or the C bsearch function to locate them.
>
>Is it worth using SQL (or building a logical) and joining the files so that
the
>database will do the work before you even see the record.
>
>One other thought (it is getting late!) is to ensure that you have "is this
the
>same key as the last one I looked for" logic around your Chain/SetLL if it
is at
>all possible that the same key will come up repeatedly.
>
>If you are processing the 300,000 record file sequentially don't forget to
make
>sure you are blocking it so that that aspect is not slowing you down.
>
>
>+---
>| This is the RPG/400 Mailing List!
>| To submit a new message, send your mail to RPG400-L@midrange.com.
>| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
>| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator:
david@midrange.com
>+---
>

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---