Re:GitHub's online schema migration for MySQL
by tomnipotent on Thursday May 03, 2018 @08:26PM
(#16991211)
>> It’s 10x as expensive as just using a FK
It's not about load, it's about locks and contention in the database caused by FK constraint enforcement. Extra read queries will barely be noticeable compared to that.
It's not about load, it's about locks and contention in the database caused by FK constraint enforcement. Extra read queries will barely be noticeable compared to that.