Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Replace Field Contents on Key field is very slow

Featured Replies

I'm importing some data from a legacy database, and in the process I'm doing some field cleanup, for example changing an ID field to strip leading zeros:

ReplaceFieldContents ( table::ID ; GetAsNumber(Table::ID) )

I'm also cleaning up some non-key fields.

Using FMA 11v3, on a database on my local SSD.

What I'm finding is that replacing data in a non-key field (one that is not used in any relationships) is about 100x faster than replacing data in a key field.

The table, and the TOG, are used in many relationships, but always on the many side of the relationship. I'm confused by this behavior, because I have only a single window open. I'm also pretty sure that I don't have any parent/child record deletion features enabled.

So -- why would filemaker care whether the data I'm updating is in a relationship field or not? I would hope that when updating data in a child record, unless the parent record was being accessed in some way, there's no need for filemaker to follow the relationship graph...

Is the slowdown simply because the field is indexed? If so, it seems like indexing is slower in FM11, or something has changed.

Any ideas about how to speed this up? I could disable indexing before the imports? Or would doing the imports & updates on a TOG that is not used in any relationships help performance?

[edited for clarity]

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.