I am using Magento Community Edition **1.9.2.**4.
Its a multi-store-webiste with 9 websites and 25 store views. At present the price re-indexing is taking 40 minutes.
This causing issue when I apply catalog price rules. It's taking very long time to complete rule apply process. At present, rule apply process is taking 30 Min's (if there 10 rules) and 40 – 50 minutes for price re-indexing (every time catalog rule apply happens price re-indexing will start automatically) Around 1.5 hours in total.
If I want to show a set of quick promotions on website, I need to wait so much time to see it on website. Is there any solution for this. ? I can't use cart rule instead of catalog.
Best Answer
By clicking “Save and apply” Mаgentо rewrites all existing rules
applyRules()is called during the function ofsaveAction()of the controllerMage_Adminhtml_Promo_CatalogController.Instead of rewriting all rules, recalculates only that one which has been edited.
Find Module
Source : http://blog.belvg.com/catalog-price-rule-optimization.html
Another solution : http://blog.belvg.com/optimizing-complex-processes-as-illustrated-by-magento-catalog-price-rules.html