4 Replies Latest reply on Mar 29, 2012 11:22 AM by TSGal

    Reindexing after global calculation field

    mcswigj

      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.