0

There is a section in the Magento 2.3 documentation that is titled EAV indexer optimization. It says that you should basically disable the EAV indexer, if you are not using a MySQL based search function.

In our case we use FACT-Finder, so this would be relevant to us. However, in our Magento 2.3.2 instance, there is no Stores > Settings > Configuration > Catalog > Catalog > Catalog Search settings section and I cannot find the mentioned options anywhere else.

Catalog Search Settings

Also I am wondering: even if you do not use a MySQL search: shouldn't the EAV flat tables still be faster for product listings etc.?

0

I believe this is because you use some custom module for FACT-Finder, and it disables Stores > Settings > Configuration > Catalog > Catalog > Catalog Search

Upd #1

Seams this isn't module; I installed it on my fresh Magento 2.3.3 and still have Catalog Search section visible. So for now, it's difficult to say what break the things.

Now I can propose you only one thing - is disable EAV Indexer directly in core_config_data table, by setting catalog/search/enable_eav_indexer to 0

You can do this with

./bin/magento config:set catalog/search/enable_eav_indexer 0

Upd #2: (answer)

After the discussion with @fritzmg we found that Magento_Search module was disabled, and therefore configuration was missed.

  • I do not see any evidence of that: github.com/FACT-Finder-Web-Components/magento2-module/blob/… – fritzmg Oct 23 at 10:02
  • hm, yes I also installed the module above, and configuration is present. – underser Oct 23 at 10:12
  • can you, please, provide a screen what exactly you see under Stores > Settings > Configuration > Catalog > Catalog > Catalog Search ? – underser Oct 23 at 10:12
  • I have added a screenshot to the original post. – fritzmg Oct 23 at 10:35
  • Regarding your post update: may be this is something that was added in Magento 2.3.3? The changelog of 2.3.3 is pretty significant and also lists a lot of changes regarding indexing. – fritzmg Oct 23 at 12:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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