Quickly deleting all records in a large table
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?