3 ms·
> Also, some young devs come up with crazy ideas (for instance, we should not use foreign keys). My favorite was "we shouldn't use indexes it slows down the DB
by giancarlostoro 5y ago
> Also, some young devs come up with crazy ideas (for instance, we should not use foreign keys).
My favorite was "we shouldn't use indexes it slows down the DB" by a junior in regards to us collectively telling him to add indexes to a MondoDB collection. When we told him to research it, we meant how to do it.
- Izkata 5y agoOne of our MySQL instances somehow ended up with two copies of the same index, and any query that tried to use them ended up being a lot slower than it should have been. Dropping the copy restored it to normal speed.
- giancarlostoro 5y agoWow, I don't even know how to pull that off. I would of thought it wouldn't let you do that!
- setr 5y agoAt least in postgres, you don’t need to provide a name, in which case it seems to do no dedup check on the create index. Quite annoying if you’re doing changes ad-hoc