Problem: very slow updates using Replace Field Contents
I'm using FileMaker Adv. 11 on a Vista computer w/ 4GB ram. I have a database currently with 4 months records totaling 86K records. When I try to update a number field for the batch entered (number) it does about 1 per second. That's over 6 hrs to replace the field with a number. I have increased the cache size from 64 mb to 128 mb with no change. Should this field be a text field instead? Anything else I can try to fix speed?