Re: Setll vs. chain

["Mark Walter" <mwalter@xxxxxxxxxx>]

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
+---