AnsweredAssumed Answered

Looking for a faster DELETE ALL

Question asked by JohnLee on Oct 29, 2013
Latest reply on Oct 30, 2013 by philmodjunk


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.