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
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.