Re:A terrible schema from a clueless programmer
by dehrmann on Sunday November 07, 2021 @12:46PM
(#29141654)
Yeah, I'm not clear on how multiple tables fixed it other than allowing you to scan through the main table faster.
Multiple tables could be a big win if long email addresses are causing you a data size problem, but for this use case, I think a hash of the email would suffice.
Re:A terrible schema from a clueless programmer
by jeremyjh on Sunday November 07, 2021 @01:48PM
(#29142248)
Well she did say she had indexes on the new table. It could have been fixed with an index on the previous table, but a new table with indexes also fixed it.
Multiple tables could be a big win if long email addresses are causing you a data size problem, but for this use case, I think a hash of the email would suffice.