On any Adobe Commerce version, because some extensions only work with flat tables there is a risk if you disable flat tables. If you know that you have some extensions that use Flat Catalog indexers, you may need to take that into consideration when setting those values to " No ".
This article describes how to solve site performance issues and slow running and stuck crons caused by flat tables and indexers having been enabled.
AFFECTED PRODUCTS AND VERSIONS
Flat indexers can cause:
Flat tables and indexers enabled.
Starting with Adobe Commerce and Magento Open Source 2.1.x and above, the use of a flat catalog is no longer a best practice and is not recommended. Continued use of this feature is known to cause performance degradation and other indexing issues. To disable the flat catalog:
php bin/magento cache:flush
.If you can’t change the Use Flat Catalog Category and Use Flat Catalog Product to No because the options are greyed out, disable flat indexers in app/etc/config.php
:
php bin/magento indexer:set-mode schedule
.app/etc/config.php
and locate the lines with flat_catalog_product
and flat_catalog_category
- change them from 1 to 0 to disable them.php bin/magento app:config:import
php bin/magento indexer:status
.php bin/magento cache:flush
.Reset stuck Adobe Commerce cron jobs manually on Cloud in our support knowledge base.