>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

Kev;

Give an example of your code. You should have your tables opened before doing this otherwise it will take time. Just one thing to look for.

Tom