I presume the website pages are slow down because of this filter to get only configurable products..

I used ->addAttributeToFilter('type_id', array('eq' => 'configurable')); this code works perfectly.. problem is page load is very very slow.

But when I try alternative methods(as follows) to reduce the page load time.. Its not working as expected and page load time is reducing but I see the duplicated product price and images on the page..

1) $_productCollection = clone $this->getLoadedProductCollection();
// Unset the current products and filter before loading the next.
                   ->addAttributeToFilter('type_id', 'configurable')

2) Mage::getResourceModel('catalog/product_type_configurable_product_collection')

3) ->setVisibility(Mage_Catalog_Model_Product_Visibility::VISIBILITY_BOTH) //catalog and search visibility

4) ->setVisibility(4);

all above methods are not working for me to show the original title, price, images.. But the page load time is reduced..

Please suggest me is there any other method to get only configurable products with correct image, price, product name.,..



If fetch collection data cost too much, please try to consider use collection cache.

$_productCollection->addAttributeToFilter('type_id', array('eq' => 
   if(Mage::app()->useCache('collections')) {

System will fetch data from cache instead of database next time.

At the end, it is strong recommended to use xdebug+kcachegrind to find the exact reason for the performance issue.


The most important step to reduce the page load time is to analyze and validate what is taking so long. A good tool for this is the AOE_Profiler https://github.com/AOEpeople/Aoe_Profiler

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