'2 tables with 10 columns works faster than a table of 20 columns' - true or false?
I was reading up on some 'too many connections' issues I'd been having, and I can across this snippet which was new to me:
This seems a bit weird. Not one to believe everything I read on the internet, I thought I'd check here. Any truth in this?
Remember that MySQL works best when moving vertically, not horizontally. If you have a table with 20 columns, breaking it into two tables with 10 columns each will improve performance. Even if you need to join the two tables together to get your data, it will still perform at a higher level.