- 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.