News for hackers. Stuff that matters.
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?
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.