I run a Magento 1.9 based store with around 40 thousand active products. Using an FPC I am able to keep the server stable sometimes, and other unstable. While checking for highest hardware consumption I found the following query with thousands of numbers related to product IDs inside the query where I wrote ...

Have you been through this problem and came to a solution ? Do you have any ideas on how to solve it ?

Best regards, Gustavo Ulyssea

** UPDATE ** These are internal queries related to filters. I found it impossible to have Magento 1 working with this number of products, event using CDN, FPC, etc. After some months working on a migration process now the site runs great on a Magento 2 installation.

SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, 
IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), 
price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position` FROM `catalog_product_entity` AS `e`

 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id 
 AND price_index.website_id = '1' AND price_index.customer_group_id = 0

 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id 
 AND cat_index.store_id='1' AND cat_index.visibility IN(3, 4) AND cat_index.category_id = '2' 
 WHERE (`e`.`entity_id` IN(36873, 43340, 43334, 43318, ...))

 ORDER BY FIELD(`e`.`entity_id`, 36873, 43340, 43334, ...)) ASC LIMIT 7
  • NO replies yet ? :( Any ideas where I can get help ? – Gustavo Ulyssea May 20 at 19:30

Unfortunately there is no clear way to solve that. Our company chose to migrate to Magento 2.3.2. It took us around 2 months to make the store sell properly, then one more month to make everything work well. Now we are making small changes o backend stuff, everything fine.

After some months answering my own question: If you have over 10 ~ 20k products you should migrate to Magento 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.