3 ms·
Multiple-long-column compound indices sucked in old mysqls if you could even convince it to use them in the first place. Being able to look up each id via a si
by mst 5y ago
Multiple-long-column compound indices sucked in old mysqls if you could even convince it to use them in the first place.
Being able to look up each id via a single-string unique index would've almost certainly worked much better in those days.
- hn_throwaway_99 5y agoI used MySql a lot back then, had many multi-column indexes, and never had an issue. More importantly, given the degree of uniqueness likely to be present in many of those columns (like the email addresses), she could have gotten away with not indexing on every column.
- mst 5y agoYour first sentence was, I'm afraid, very much not a universal experience. Your second is quite possibly true, but would have required experimentation to be sure of, and at some point "doing the thing that might be overkill but will definitely work" becomes a more effective use of developer time, especially when you have a groaning production system with live users involved.