speeding up report writer

[Mike_Dekle_(Guest)]

Hi,____We are currently using version 9 (xbase) to pull information from M.O.M. to update our shipping system. The program currently has to look at all 980,000 orders before finding the last 600 that I need the information for. Short of purging M.O.M., is there a way I can speed this up? Currently it takes about 20 minutes to find and export the data.____Thanks!

[kfleming]

If you just want to see records at the end of the master file, you can use Database Master Table and set the scope to the last x records in the file by setting the starting value to the record that you want to begin with.____Kathleen__R&R Support

[Mike_Dekle_(Guest)]

WA-hoooo____Thanks!

[Nick_McLarty_(Guest)]

>If you just want to see records at the end of the master __>file, you can use Database Master Table and set the scope to __>the last x records in the file by setting the starting value __>to the record that you want to begin with. __>__>Kathleen __>R&R Support ____Speaking of that... is there any chance of being able to set the starting record to be x number of records from the end? (i.e., instead of setting "record 39304" as the starting value, it would be "100 records from the end"), that way we wouldn^t have to keep updating the starting value as the table grows.

[rickwjohnson]

I did not try it, but it seems to me that you could setup a variable (maybe a ParameteRR) that uses Reccount(record count) - 100. This way, if you have 1000 records in your file, the scope would start at record 900. See Help for a description of Reccount().____Rick Johnson__Rick Johnson