3 ms·
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 e
by dehrmann 5y ago
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.
- jeremyjh 5y agoWell 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.