AnsweredAssumed Answered

Quickly deleting all records in a large table

Question asked by ChrisC_3 on Aug 18, 2015
Latest reply on May 28, 2016 by beverly

Title

Quickly deleting all records in a large table

Post

Hello,

The problem may seem simple. I have an import script that has the job of first cleaning out a table and then importing a fresh set of records from another (ODBC SQL) database.

The problem is that clearing out these tables with the Delete All Records script step takes an incredibly long time, longer than actually importing fresh records. Is there any way to prep my Filemaker Database (within the import script) to accelerate this process?

Outcomes