Re: Setll vs. chain

[Jon.Paris@xxxxxxxxxx]

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