By mwu on
I'm using many cck text fields for first name, last name, etc. I guess the default field length is 255. (is that right?) If I limit it to 50, does it help or hurt performance? thank you.
I'm using many cck text fields for first name, last name, etc. I guess the default field length is 255. (is that right?) If I limit it to 50, does it help or hurt performance? thank you.
Comments
Just guessing
Servus.
Haven't had a look at those tables yet, but I suppose setting a length for a string should be helpful in any case as things beccome more predictable. However, the cck help says nothing about the length but "unlimited", so it may well be it deals with mysql text columns if no length is given, and with varchar if the specified length is less than 256 chars. Anyway, I prefer setting fields to a "sane" length -- there's no need for 255 char (let alone unlimited) zip codes :) And if I remember right, indexing won't work with text columns exceeding a certain number of chars. That of course could hit performance badly...
Norbert
-- form follows function
Norbert
-- form follows function