Hello,
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!
Please, any advice would be greatly appreciated!
Mark