Another Optimal Hardware Configuration

[merkaba22]

In a small network with a new 22.5" iMac w/4GB serving FM 9 to 2 older iMacs w/2GB running 8.5 for a file about 50MB with 13 tables and the main "data" table having 64 fields and 79K records to date.

All the scripts and relationships seem to be running fine but there seems to be an unusual data corruption issue -- sometimes a portion of the 79K records disappear while not crashing the computer or the file -- the file has been "recovered" using FM 11, compacted, copied to another disk and back and the processed repeated, Disk Utilities/Permission run, etc.; early on, about two weeks ago there was a repair via "recover" that was assumed to address the oddity, but the issue remains:

Yesterday, a user on one of the two older iMacs observed that in one moment all the records were there, turned her head (there were no other users at the time and FM was idle) and when she looked back 5 seconds later, all but 4600 records were missing and the file size dropped form 50MB to 17MB without crashing. The other tables were fine.

Its been recommeded that FM Server on a MacPro w/ 4.5 GB RAM and a separate drive for the solution where the data table is separated out to a second file will resolve.

Any ideas?