RE: Fastest way to delete records.

["York, Albert" <albert.york@xxxxxxxxxxxxxx>]

It depends on what the time stamp represents. If it correlates to the order
the records were written and the records that you will be deleting are at
the beginning of the file then the fastest way is to read the physical file
in arrival sequence. Stop processing when a record past the cutoff date is
reached.

Otherwise, a logical is probably your best bet.


        -----Original Message-----
        From:   Quazy [SMTP:quazy@SoftHome.net]
        Sent:   Wednesday, February 07, 2001 1:04 PM
        To:     rpg400-l@midrange.com
        Subject:        Fastest way to delete records.

        I have a file with about 10 million records.  It is keyed on
Company #, 
        Employee #, and Time stamp.

        I need to delete all records that have a time stamp before a certain
time 
        period.

        Any suggestions on the fastest approach?
        Speed is a very important factor. 

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