4 Replies Latest reply on Oct 30, 2013 12:33 PM by philmodjunk

    Looking for a faster DELETE ALL

    JohnLee

      Title

      Looking for a faster DELETE ALL

      Post

           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.