Looking for a faster DELETE ALL
I import a large number of records (over 1 million) once a month. Once I'm done with the records, I want to delete them all in preparation for the next month. However, it takes anywhere from 15 to 20 minutes to DELETE ALL as FMP seems to delete each record one at a time.
Is there a command similar to the CLRPFM on the IBM AS/400 computers which simply clears a physical file by apparently resetting the number of records to 0 and freeing up the storage (it takes only a few seconds no matter how large the file is) ?
I still see the value of the DELETE ALL for a found set, but perhaps a different command to delete all the records in a file.