0

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)

or 2.

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.

2
Contributors
6
Replies
7
Views
6 Years
Discussion Span
Last Post by minitauros
0

I was just giving an example ;). Let's say "the largest number available for varchar" then.

0

That's the question :). Would it make difference if the varchars were used to their max? So if they were completely filled?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.