Database Indexing by Custom Field in Craft CMS

Andrew walks through how he created a database index for a custom field in Craft CMS to improve performance.

Craft 4

Lesson Materials

Some stuff to help you along during the lesson:

Indexing by Custom Fields in Craft CMS

Craft CMS content migration (Github Gist)

Adding custom field index migration (Github Gist)

Functional Indexes

More you should learn about Performance

Improving Performance with Custom Field Functional Indexes in Craft 5

CraftQuest on Call: Functional Indexes

Caching Strategies with Blitz

Lazy Eager Loading Using eagerly() in Craft 5

CraftQuest on Call 81: Entry Query Caching

CraftQuest on Call 75: Questions and Indexes

CraftQuest on Call 46: Technical SEO

CraftQuest on Call 45: Inside CraftQuest, Part 2