My Magento store has around 60,000 products. We use flat tables. We are in the process of separating them into different attribute sets, and are adding lots of new attributes to assist with filtering and comparing, etc.
Recently we ran into a database limit from having too many attributes while indexing our flat product catalog:
SQLSTATE: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535.
Now I know there are ways to adjust Magento to handle this, but the way I see it is that this problem will resurface again and again as the number of attributes in our system increases (which it will).
New question: Should I disable the flat product catalog and run my site off EAV? At what point (if at all) do the flat tables lose their performance gains over EAV? Does anyone have any useful performance benchmarks comparing the two at different database sizes?