8 Replies Latest reply on Dec 12, 2016 3:29 AM by fmpdude

    Calculated field takes long time to update


      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.