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.

Outcomes