Re: Cost of using over dimensioned columns

2009-02-25 Thread Olaf Stein
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

Cost of using over dimensioned columns

2009-02-25 Thread Morten
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