Re:Leaving MySQL
by js4ever on Monday December 06, 2021 @02:06PM
(#29464150)
At "scale" you just can't afford to use FK, it's indeed slowing down everything and preventing good and fast clustering / replication. For some use cases you just have to live with it
[ Parent
| on HN ]
Yup for sure, that's what they were saying. It makes sense, but I was still surprised by it. I've never had to manage something at this scale before, so it was news to me.
For reference, we're at about 250 million rows, so not even proper "scale" scale!