create table testtable ( test varchar(100) not null, )
The question: Will this 100 Byte be allocated (or something like that) before Usage, or is
it really complete dynamical, like the name suggests?
In the theoretical case, that in every row, only the first 10 bytes will be
used, would there be any difference using:
test varchar(100) not null,
and test varchar(1000) not null,
concerning memory consumption and stuff?
Apart from the size on disk (which Elke covered), there is also the size - in intermediate result sets - when copying the data over the network
In both cases, VARCHAR columns will often be padded to the defined size. This will have a negative impact on the performace of your aplications.
Daniel Dittmar
-- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED]
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
