Their answer was "oh shit, EAV is cool until it sucks, lets make flat tables". Those flat tables really don't help much... (just profile the a request made to

Their answer was "oh shit, EAV is cool until it sucks, lets make flat tables". Those flat tables really don't help much... (just profile the a request made to them and you still see the insanity that kcachegrind can generate). They also didn't think about stores that have a lot of attributes. We had over 650. That means we had MySQL tables with 650+ columns. Then there are SKUs. We had hundreds of thousands. Now there are HUGE tables with LOTS of columns that needs to be indexed on a regular basis because products and more attributes are being added. Reindexing takes hours. Magento is a mess and that's all I have to say about it.