>Hi
>
>I have a program that SCAN's through an entire table (few thousand records) and for each record, SEEK's on another table, and then INSERT's into another table.
>
>This program gets progressively slower as it runs, why is this?
>
>Thanks
>Kev
Hi Kevin,
If the table into which you are inserting is indexed, you might find it substantially faster to remove the indexes while you run this INSERT-looping logic. Then when the INSERT processing is done, add your indexes in one fell swoop.
Also keep an eye out for any potential Rushmore optimization issues, e.g. when SET DELETED is ON but there is no corresponding index on deleted().
Another thing you could do is try out VFP's coverage profiler to get a better idea of exactly where the time is being eaten up.
Mike