Something for everyone

We all like fast ... stuff, right?

I found some old "secret" optimizations for Magento recently. I had this crazy idea that people would pay money for Magento "tune-ups" on their servers... but that's another story. I found four SQL index additions. After analyzing the Magento DB from way back when, I found 4 semi-crucial indexes missing, two of them have made it into M 1.3.0 already. Here are the other two:


ALTER TABLE `poll` ADD INDEX ( `closed` )

ALTER TABLE `catalog_category_entity` ADD INDEX ( `path` )

I don't know if these are even relevant anymore.