This is an annoying bug that is still an issue with the current version of Magento (v1.7.0.0 as of this writing). I have opened Issue #27867 with Magento and am hoping that this can finally be resolved in the core code. In the meantime, to fix this issue we need to make a tweak to […]
In earlier versions of Magento you may have noticed that saving products is horribly slow especially as your site grows. This problem originates from a bug in MySQL 5 (bug #42259) where using “IN” can dramatically decrease performance. This appears to have been corrected in Magento 1.7.x. However, if upgrading isn’t an option for you […]