Okay so me and a friend of mine are discussing the following:
If you have 1.
a table with 10 fields, each a varchar(255)
a table with 10 fields, each a varchar(1billion)
Which would be better, performance wise?
I say it won't matter, because MySQL reads the field names before it scans the content. My friend says it will matter, because the field size always impacts the performance of the scanning process.