hessodreamy — 2011-09-01T04:16:09-04:00 — #1
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:
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.
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?
hessodreamy — 2011-09-01T08:16:21-04:00 — #2
Thought it sounded like rubbish.
starlion — 2011-09-01T08:37:52-04:00 — #3
Mmh... well, the middle of the statement might be true?
If you dont have to join the tables to retrieve your data (IE: You only wanted data from one of the tables), wouldnt it improve?
As soon as you join of course it'll go downhill.
r937 — 2011-09-01T07:11:34-04:00 — #4
maybe on mars...