The problem is that when Magento tries to load the search results by some ids, it does not take the same number of products as it should be. I debugged and saw that despite the fact that we're using flat tables, Magento's query is build on EAV tables.

I verified that in Sustem->Configuration->Catalog->Frontend to specified Magento to use flat tables but it does not work.

Mage_Catalog_Model_Resource_Product_Collection->isEnabled() returns false and because of this, the flat tables are not used. I guess?

Mage::helper('catalog/product_flat')->isEnabled() returns true, so I guess flat is enabled after all.

Am I missing something?

  • Did you make reindex?
    – electroid
    Commented Sep 10, 2016 at 15:37

1 Answer 1


If you use the collection in the admin area, flat tables are never used.

It also can be that the flat tables are not used while the indexer is running. Check the indexer status in the index management.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.