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.