Any way to speed up the layered navigation? I'm using a Manapro Filtered Navigation extension for some extra features, but it still takes about 5-6 seconds when I change each filter.

I only have 5 visible filters, so hopefully it's not that. There are about 65k variations of products, so I don't know if it's just that, and maybe I need to look into speeding the mySQL queries somehow?

Any ideas?

1 Answer 1


For each attribute you have in Magento and that is marked as filtrable, it will make a call to getAllOptions() of attribute source model. Even if there is no filter results for it, it will invoke attribute option collection load. Possible solution other optimization tips described here:


Also make sure the layered navigation block is cached ( many simple extensions just skip this)

Try solr based layered navigation as well.

Server performance is also important.

  • Where do I make sure the layered navigation block is cached? Is it in cache management settings?
    – zen
    Aug 19, 2014 at 16:09
  • Is it "Blocks HTML output" part of the cache?
    – zen
    Aug 19, 2014 at 16:17
  • You need to debug this, to see if it works, not just enable.
    – Amasty
    Aug 19, 2014 at 17:41
  • ok thanks. One other question. I'm trying to extend the Mage_Eav_Model_Entity_Attribute_Source_Table per your link, but I don't know how to exactly set up the config file for it so that Magento reads the new class. i.imgur.com/cIWRx5F.png
    – zen
    Aug 21, 2014 at 21:26
  • Please search for "magento rewrite classes". You can either create your new module or do all modifications in /local/Mage/
    – Amasty
    Aug 22, 2014 at 23:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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