View RSS Feed

Wess3213

  1. Many-to-many relationship pivot table vs storing ids directly inside one of the table

    From the perspective of the code of the app we're developing around this database, this this doesn't seem to give any benefit. It's actually easier to have a pivot table because the framework we're using makes many-to-many relations trivial.
    Is there more to it? Is there a performance benefit to doing it this way? I'll be the first to admit SQL in general is not one of my stronger points, so am I missing something?
    Categories
    Uncategorized