AnsweredAssumed Answered

File maintainance - FM15

Question asked by Abingdon on Mar 9, 2017
Latest reply on Mar 17, 2017 by gdurniak

Hi All,


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.


Many thanks.