Allow recovery of individual tables

Idea created by infoCypher on Aug 23, 2016
    Active
    Score-1
    • No one has voted for this idea

    It would be great to be able to re-index or compress individual tables within a file instead of the whole file.

     

    I have a client whose database holds millions of records, and we re-index files using the File->Recover option on regular intervals (every month or so) to keep the files from crashing unexpectedly.  The re-indexing of entire files can take a very long time (sometimes 11 hours or more), and there's no way to do this just for one table at a time.  It forces my client to keep data separated into multiple files like we had to in legacy FileMaker solutions, just so that the file maintenance is possible.  If we could re-index or compress data in tables within a file, we wouldn't have to have these multiple files.