Re: Changing records in a big file

Chris, on thing I've done with good results is to make the most stringent 
search first.  Lets say you wanted all People who's name started with "A", 
were born in 1963, and were male.  Do the check for 1963 first, then for 
"A", then for Male.  Also, be sure there is no "K" on the F-spec line. 
Sequential reading of a 4,000,000 record file shouldn't take 4 hours if 
you read in arrival sequence. 


_______________________
Booth Martin
boothm@earth.goddard.edu
http://www.spy.net/~booth
_______________________




"Chris Beck" <CBeck@good-sam.com>
Sent by: owner-rpg400-l@midrange.com
02/04/2000 04:43 PM
Please respond to RPG400-L

 
        To:     <RPG400-L@midrange.com>
        cc: 
        Subject:        Changeing records in a big file


I have a 4 million record file that I need to change some records in if 
they meet certain criteria.   What are some things I can do to speed this 
up. obviously sequential reading of the file is out of the question at 
over 4 hours to run.  I would prefer not to use the SETLL if possible, 
because I don't want to have to go in to the file and see what record to 
start with. 


thanks for any help. 

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