>> It’s 10x as expensive as just using a FK It's not about load, it's about lock... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

tomnipotent on May 4, 2018 | parent | context | favorite | on: GitHub's online schema migration for MySQL

>> 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.

gaius on May 4, 2018 [–]

it's about locks and contention in the database caused by FK constraint enforcement

What locks do you mean?

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact