I need to re-populate a table nightly but it takes quite a long time to do so, are there faster ways?

I'm launching a script that erases all records (340k of them) then imports a new complete list from ERP system via ODBC. My issue is the delete part, which takes some minutes. I remember FMP5 did this in just seconds... Does it really have to iterate through all records and delete them in order when all I want to do is truncate the table?

Instead of deleting all of the records and then importing to an empty table, try showing all records and using the "update existing records in found set" feature of Import.

This will recycle the existing records. The found set after the import will be all of the records that were imported.

If you have less records to import than were previously in the table, Show Omitted Records to see the extra records that were unaffected by the import and delete just those.

Edited September 15, 201015 yr by Guest

FMP has to spend some time working out which related records need to be deleted through the relationships. This can sometimes be reduced by deleting the child records first.