In Panorama 6, have about 100 databases, each with about 30,000 to 100,000 records. Each includes a record counter field called Kount. For some thousand or more of these records, I need to compare the value of a field in the current record with the values of that field two records up and two records down. Obviously, I need to find the most efficient way to do these comparisons.
The simplistic approach is to do two
DownRecord and two
Another is to do a
Find for Kount two less than the current record, then for Kount two more and then the current Kount.
Finally, I could put the whole database (only six fields) into an array and use the
array( function to extract the values.
I'm in the process of setting up a test procedure to time a couple of thousand of each of these methods but I would appreciate any comments on the options and I'd love to hear about a much more efficient solution.