5

Our search index table (craft_searchindex) is over 500,000 rows and it takes a few hours to index. We have 11 languages, and each is being fully indexed. It takes a few hours to complete.

Are there any ways we can reduce the search index size (e.g. only one language, or specific sections?

1
  • 1
    Mine is currently sitting at ~1.1M, taking up around 93MB, or half the database size. This is killing performance Mar 5, 2017 at 13:25

1 Answer 1

3

Craft 3:

In Craft 3, a plugin can listen to the Element::EVENT_REGISTER_SEARCHABLE_ATTRIBUTES event to modify the searchable attribute list of an element before it is indexed.

Craft 2:

Currently the answer is no.

Maybe it makes the case for some sort of onBeforeSearchIndex event a plugin could listen to and influence what Craft adds to the search index, but given that manually updating the search index isn't meant to be a common occurrence (Craft keeps them up to date in normal element saving operations), I'd probably add the workflow you're using that requires frequent updates to the feature request.

2
  • Is that for Craft 3 as well? Oct 8, 2019 at 13:45
  • @FrankLämmer Updated answer for Craft 3.
    – Brad Bell
    Oct 14, 2019 at 18:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.