Use Flat Catalog on Categories and Products

General help articles for Magento® 1. We've tried our best in the preparation of this help article. If you do not find the answer you were looking for, you can always send us a message through this form.


Use Flat Catalog on Categories and Products

Enable Flat Catalog
Using Flat Catalog Category and Flat Catalog Product is a great solution for optimizing Magento store. This will help to reduce queries to database a lot.

Access to your Magento Admin Panel then System > Configuration > Catalog > Catalog > Frontend
When flat catalog is enabled in Magento then all the above product attributes (id, name, price) are kept in one table named like catalog_product_flat. Then Magento fetches product data from the flat table rather than joining all the other smaller tables.

You have to rebuild Flat Catalog using Cache Management and Index Management.