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.