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.

Outcomes