I'm running some local test with about 50k products using EE 1.14, it's very slow on saving updated product info, after I install Redis and get Magento configed with Redis cache, the speed did improve quite a bit, but still taking about 30 seconds to complete the save(checked the CPU jumped to about 25% usage, no obvious memory jump, but did trigger heavy mysql disk IO), just wondering what could be the other ways to improve the speed?
The quick way to resolve this problem is to turn off update index on save option in admin, but the question is: is there another way to make it work fast with the update index on save option? or we need to run index in a cron job as best practice?
