In website 150k products,I have installed varnish cache but when initial load category page it takes 10 second to load time and display 36 products in category page and I do not want to change 36 to less pagination. I want to load category page in less time so how can I optimize query product collection?

I think it needs to optimze Collection from block Mage_Catalog_Product_List. and method used is _getProductCollection() so how to optimize in collection in _getProductCollection() method. Please guide me. I am using dedicated server. If anyone can give another solution it will appreciated.

Edit: I have already enabled flat catalog option.

  • do you have configurable product swatches on that listing page ? Feb 24, 2017 at 8:20
  • No but product listing is configurable Feb 24, 2017 at 8:21
  • I want to decrease first time load listing page time Feb 24, 2017 at 8:22
  • so you dont have swatches on listing page ?? Feb 24, 2017 at 8:24
  • I know that swatches takes time to load page but no swatches in listing page Feb 24, 2017 at 8:26

1 Answer 1


Kindly visit below URL for speed optimization for category pages. It is very helpful for you.

Category (configure product):

URL : https://astrio.net/blog/magento-performance-optimization-configurable-products-2/

Product page (configure product):



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.