Page 1 of 1
speeding up report writer
Posted: Wed May 14, 2003 10:33 am
by 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!
=> RE: speeding up report writer
Posted: Wed May 14, 2003 3:29 pm
by 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
==> RE: speeding up report writer
Posted: Wed May 14, 2003 5:13 pm
by Mike_Dekle_(Guest)
WA-hoooo____Thanks!
==> RE: speeding up report writer
Posted: Sun May 25, 2003 9:21 pm
by 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.
===> RE: speeding up report writer
Posted: Mon May 26, 2003 2:43 pm
by 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