- How to set Frontend catalog flat indexing to true
Go to Magento Admin Panel
System →Configuration→Catalog → Frontend →Use Flat Catalog Category
Use Flat Catalog Product
- Why Enable Flat Catalog?
In Magento, all product and category connected data is stored in the database. The database consists of collection of tables. There are number of tables. When Magento found number of tables for different data that’s scattered, it can becomes slow. Hence, Enable Flat Catalog Category and Product which reducing the response time.
How to create Custom Indexes?
In this section, we will explain how to create custom indexes in Magento. There are following steps which is used to create indexes.
Which tables are used in Magento Indexing?
What is Magento index_event table
What is Magento index_process table