Magento Certified Developer GuideCategory: 7. CatalogHow is a catalog tree read from the database tables, with and without flat catalog tables enabled?
Manish Prakash Staff asked 5 years ago

The model class which is used read the category tree is “catalog/category_tree” (this is a resource model) so its inside the Resource folder.

The model “Mage_Catalog_Model_Resource_Category_Tree” extends “Varien_Data_Tree_Dbp” which is used to read the entire category tree.

In case of flat tables the tree structure is read from table “catalog_category_flat_store_1” and in case of EAV tables tree structure is read from “catalog_category_entity”
Rest of the code is totally same only the main table names are different