IOWEB TECHNOLOGIES

Even after changing all to No I still get this query ``` SELECT `operating_system_idx`.`value`, COUNT(operating_system_idx.entity_id) AS `count` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1...

I'm thinking that the culprit may be here as it's one of the few areas I can see that match the query about count(attribute_code_idx) ```php //app/code/core/Mage/Catalog/Model/Layer/Filter/Attribute.php:115 protected function _getItemsData() {...

Check how I replicated it. I went in a category page with 16 filters in the sidebar's layered navigation (smartphones as products which have a lot of filters) I progressively...

True it's very complex but I think the problem is still that count query. Since I configured the backend not to show the count, shouldn't this count query be totally...

I posted this on https://dba.stackexchange.com/questions/338347/why-is-this-query-running-so-slowly/338372#338372 Where Dan Black was kind enough to take a look at this. His last suggestion was to set the `optimizer_search_depth = 1` From the default...

@fballiano I found the way to mitigate this for now. On local.xml there's a section called ```xml ``` I modified it like this for the site experiencing the issue ```xml...

Same here :( 

My case is only for the list page , not the product page so I think it's related but not the same

Yes I still face it unfortunately.

OK I replicated on the vanilla instance for this. Do the following steps. 1. Create one configurable product and put in stock  2. Create one variation and set qty...