Re:Ask HN: What length do you choose for email fields?
by zbanks on Thursday December 09, 2010 @10:37PM
(#1990490)
I tend to err towards 256.
My rationale is this: what percent of the DB will the extra 156 characters take? If I have 1K or less users, an extra 150KB of storage is negligible. If I have 1M users, 150MB is also silly.
Re:Ask HN: What length do you choose for email fields?
by kondro on Thursday December 09, 2010 @11:37PM
(#1990635)
I guess, but I don't want to run into the 1KB index size per row limit in MySQL (unless that has changed without me knowing) either and I have other fields I want to index as well.
My rationale is this: what percent of the DB will the extra 156 characters take? If I have 1K or less users, an extra 150KB of storage is negligible. If I have 1M users, 150MB is also silly.