Option to disable the search index via the config file

[alexanderloewe]

We have a medium size site with about 500 entries, but the search index has a size of 150 MB in the database.

At the moment we do not use any search function on the frontend, so i'd likt to disable the building of a search index into the db.

[brandonkelly]

You can prevent elements’ search keywords from getting indexed using the craft\services\Elements::EVENT_BEFORE_UPDATE_SEARCH_INDEX event. Add this code to your module:

use craft\events\ElementEvent;
use craft\services\Elements;

Craft::$app->elements->on(
    Elements::EVENT_BEFORE_UPDATE_SEARCH_INDEX,
    function(ElementEvent $event) {
        $event->isValid = true;
        $event->handled = true;
    }
);

Note that this will also affect the search bar above element indexes within the control panel, which will likely frustrate authors, so not recommended.

Instead of disabling element keyword indexing altogether, you can prevent all custom fields from getting indexed, which will reduce the overall index size considerably. To do that, go to Settings → Fields and edit each field with a search icon (). For each one, uncheck its “Use this field’s values as search keywords” setting. Also go into any Matrix, Super Table, and Neo fields and ensure that their sub-fields have that same setting disabled.

Once you’ve updated each of your fields, you can truncate your searchindex table, and then run the following command to re-index each of your entries without their custom fields’ keywords:

php craft resave/entries --update-search-index

[alexanderloewe]

Perfect, I will try that one.

Sure, the search index is used in the backend as well ;)

[alexanderloewe]

We have over 150 fields, that would be a bit of work. And maybe we will need the search index in the future.

[brandonkelly]

Alternatively you can do it like so:

1. Run the following command to rebuild your project config data:

   php craft project-config/rebuild

2. Replace any instances of searchable: true with searchable: false within your config/project/ folder, using a text editor’s Find & Replace feature.

3. Run the following command:

   php craft project-config/apply

[alexanderloewe]

Good one, I don't had that one in mind 😂