3 ms·
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 stora
by zbanks 16y ago
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.
- kondro 16y agoI 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.