AnsweredAssumed Answered

Reindexing after global calculation field

Question asked by mcswigj on Feb 14, 2012
Latest reply on Mar 29, 2012 by TSGal

Summary

Reindexing after global calculation field

Product

FileMaker Pro

Version

11.0.4

Operating system version

Mac OSX Lion

Description of the issue

FileMaker reindexes all 6,000,000 records in my database when I add a global calculation field

Steps to reproduce the problem

I have a 9 field database with >6,000,000 records. It took most of a day to index all of the fields, but now that should be done and not need changing. I then added one global text field and another global calculation field based on that global text field. Creation of these two fields have nothing to do with the other 9 fields, so there should be no need to reindex the other fields. Unfortunately that is not the case. Creation of these fields, and then a slight correction to the calculation field results in a >1.5 hour wait (each time) while Filemaker reindexes. That doesn't seem right.

Expected result

Filemaker should immediately close the Database Manager window and not have to reindex anything.

Actual result

Creation of these fields, and then a slight correction to the calculation field results in a >1.5 hour wait (each time) while Filemaker reindexes. That doesn't seem right.

Exact text of any error message(s) that appear

None.

Workaround

None.

Outcomes