Mark,

This is typically an indication that you do not have all the correct indexes for full Rushmore optimization. You can use SYS(3054) to check this. What are you using to do the processing SQL-SELECT? Scan loops? SET RELATION?

>We have a VFP 5.0 application that processes a table with 1.2 million records that runs incredibly slower than it does with 500,000 records.
>The process is a simple matter of grouping each record by one of three fields; i.e, find a matching record on field1, if no match, find a matching record on field2, if no match, find a matching record on field 3. Each of these fields has an index for this purpose.
>We are using a new, 450mhz PII w/128M ram. We have tried several things, such as SYS(3050), and numerous coding methods, but basically, when the table reaches a certain size, the process grinds to almost a halt. As I mentioned, 500,000 records can be done in about 20 minutes, whereas 1.2 million is only 13% complete after 2 days!