3

In Magento we can choose not to have Flat Category and Flat Products.

My question is simply what actually is being reindexed by the Category Indexer / Product Attributes Indexer if we don't enable Flat Category and Flat Products? Since we're not flattening / denormalizing anything.

1 Answer 1

0

In a nutshell Magento uses an Entity-Attribute-Value (EAV) database model which gives great versatility but sucks for performance. Effectively the fields and related information are stored in one table and the values are stored in a different table. Which table the values are stored in depends on the type of value - an integer, varchar, text, etc.

By using the flat tables Magento effectively pulls data from all of these different tables and builds a single database table that represents the main fields required for your categories and your products which means queries have to access far fewer tables and therefore run faster.

However, you probably know all that.

Even if the system>configuration>catalog "user flat catalog category" is set to "no" the indexers still do the indexing creating all the contents for the catalog_category_flat_store_1 table. Whether that table gets actually used is another thing.

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.