Do all the things like ++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatarSign Up
And run in staging first.
Yeah, doesn't have to do with indexes but with foreign keys...
They were probably set to "ON DELETE CASCADE" which just means, if the parent dies, kill all records associated with it :p
Atlas1174883y@FMashiro yep. Figured it out the next day, we found out there are 72 cascades across the database from when the company got the bespoke web and db, miracle no one tripped it prior since they're pretty lenient with the use of DELETE-INSERT.
Bonus: our entire server was down the past two days and no one knows why. House of cards my friend...