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

    Calculated field takes long time to update

    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.