FileMaker Tips #2 — To Index or Not to Index?

Indexing Options

How does indexing improve FileMaker finds?

What do the three options do for indexing?

  1. None is pretty self-explanatory. No index will be created for the field, unless the Automatically create indexes as needed setting is enabled. I will touch on this setting a bit more later.
  2. Minimal means that only the value index will be created for the field. This only applies to the text fields since there can be a word or value index.
  3. All means that both the word index and value index will be created for the field.

What is “time spent indexing?”

  1. Grab a database that has a pretty heavy table of records.
  2. Take a field you already have indexed. If you look at the field definitions for a table it should say “indexed” under its options.
  3. Turn off the indexing to clear out the indexing for that field by setting it None.
  4. Save your changes.
  5. Return to the field and enable Create indexes as needed.
  6. Save your changes.
  7. Perform a find on the field.
  8. Perform a second find on the field.

How do I optimize indexing of my solution?

Quick Finds

Quick Find
Quick Find option in Layout Setup
Quick Find setting in Inspector

Insert from Index (Ctrl + I)

Insert From Index dialog
Insert From Index with Individual Words enabled.

Final Words

  • Turn off indexing for fields that don’t need to be indexed.
  • Turn on Minimal indexing for text relationships and for most text fields that will not have multiple words entered in.
  • Adjust Quick Find settings to ensure that you or a user don’t unintentionally force a full indexing of an entire table.

Want Me to Cover a Specific Topic of FileMaker Development?

--

--

--

Software Developer and Code Ninja

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Reflect on this phase and the project that you have completed.

Why PHP is The Best Choice for Web Development?

Django Model Guideline

Which Is The Better Framework — Ionic or React Native?

2.5D Platformer: Moving Platforms, Part 1

Manage Amazon S3 Buckets using Terraform 🪣

Creating a Discord bot using Javascript

Tired of logging regularly to your K8s/OpenShift environments ? You gotta read this my friend

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Jeffrey Henry

Jeffrey Henry

Software Developer and Code Ninja

More from Medium

Unorthodox Half Marathon Training Blog 3

Continuous Sub Array Sum (Leet Code)

Koko Eating Bananas — Day 106(Python)

A Beginner’s Guide to Pulp and Pulpscript (Part 1)