Morten,
Check out
http://dev.mysql.com/doc/refman/5.1/en/storage-requirements.html
For example, the cost of longtext (L+4 bytes) over mediumtext (L+3 bytes) is
1 byte per record. If you have a lot of records this might be significant.
In the case of varchar it is similar, L+1 if less than 255 by
Hi list,
I'm wondering what the "cost" (if any) is by using eg. mediumtext
over text, or largetext over mediumtext. Is there a non-negligible
reason to not just just largetext?
And how about varchars, what's the "cost" of using varchar(1000)
rather than varchar(20)?
My intuition tell