News for hackers. Stuff that matters.
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.