Re: Feedback on approach requested

[rob@xxxxxxxxx]

Suppose you had to query this file that had 2 million records.  In it is a 
load number and a date, perhaps state, etc.  And every time you 
added/updated/deleted a record in this database, it would automatically 
update another file that was summarized.  Perhaps only three fields: Date, 
number of loads, state.  Or some such combination.  You could add a 
trigger to the 2mil record file that would automatically update this 
summary file.  That way you would not have to modify one line of any of 
the program(s) that update the big file.

Rob Berendt