AnsweredAssumed Answered

Calculated field takes long time to update

Question asked by fmpdude on Dec 11, 2016
Latest reply on Dec 12, 2016 by fmpdude

I have a calculated field with a two-table SQL Join.


Only about 300 records in one table and only 100 or so in the other.


Yet, every time I modify the calculated field, it took FMPA 14.0.6/Mac several minutes to go through just 300 records and update each field.


What if I had 50,000 records, or 500,000?


Just wondering how I should handle such slow calculated field update performance.


Should I make the field unstored?  If I did that, then there would be a delay each time the user went to a new record? If true, that wouldn't be good either.


Thanks in advance.