This module adds database indexes to certain custom field types (text, string, and their variations) to improve the performance of searching and filtering content in views. Without these indexes, views that use these fields as search criteria can result in slow queries due to full table scans.
Drupal custom fields do not add indexes to field values by default. This will cause a problem. When you expose this field as a search field in views, the execution will scan the entire table. The performance will be very slow.
You can use the following to test
EXPLAIN SELECT * FROM `node__body` WHERE body_value LIKE "hello"
You can see that the number of rows is the total number. This is because MySQL will perform a full table scan for non-indexed table searches.
Features
Index Support
- text
- text_long
- text_with_summary
- string
- string_long
How to use
- go to /admin/structure/types/manage/yourtypes/fields
- edit field and chose Add Index
- save and run drush entity-updates (https://www.drupal.org/project/devel_entity_updates)
Ask your assistant about Field Add Index
Check compatibility with your Drupal and PHP version, maintenance and security coverage, from current release data. How it works
Depends on
Dependencies of the latest stable release
No dependencies recorded for this project.
Required by
Tracked projects that depend on this one
No tracked projects depend on this one yet.