I have a fairly large solution hosted on FMS 14. 30 files with multiple tables, whole thing approx. 3gb. Approx half a million records. With 80 odd users constantly adding records, doing Finds etc. etc.
Although there are no obvious problems, I would like to take some time out to do some 'housework'.
On a back-up of course, I was thinking of compacted the files, setting the indexed fields to 'None', then re-indexing.
I would very much appreciate some 'best practice' suggestions. Should I run a Recover on copies to check for any damage prior to the above?
Anyway, any suggestions will be very gratefully received as always.