Re:Scaling Databases at Activision [pdf]
by vecter on Friday April 21, 2023 @05:44PM
(#35660624)
I see, thanks. Basically just store the foreign keys yourself as columns in relevant tables and perform the joins in SQL without having the DB enforce FK integrity with every insertion/update/delete. Would it be fair to say that read speeds are unaffected by this?
[ Parent
| on HN ]
Re:Scaling Databases at Activision [pdf]
by berkle4455 on Friday April 21, 2023 @05:53PM
(#35660729)
Yes. Quite literally the only difference is not enabling foreign key constraints.
Read speeds unaffected correct.