1

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 ? – Murtuza Zabuawala Feb 24 '17 at 8:20
  • No but product listing is configurable – Niraj Patel Feb 24 '17 at 8:21
  • I want to decrease first time load listing page time – Niraj Patel Feb 24 '17 at 8:22
  • so you dont have swatches on listing page ?? – Murtuza Zabuawala Feb 24 '17 at 8:24
  • I know that swatches takes time to load page but no swatches in listing page – Niraj Patel Feb 24 '17 at 8:26
2

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):

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

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.