#1
  1. A Change of Season
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Mar 2004
    Location
    Next Door
    Posts
    3,536
    Rep Power
    221

    What are the downsides of a redundant field?


    user_id is not needed in launches table.
    But it makes it easier since I don't have to make as many joins.
    Also visually it's easier.

    What are the serious downsides?
    Code:
    //launches table
    +++++++
    launch_id
    user_id
    product_id
    
    //products table
    +++++++
    product_id
    user_id
  2. #2
  3. Impoverished Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Mar 2007
    Location
    Washington, USA
    Posts
    16,797
    Rep Power
    9646
    Depends if the data needs to be updated, and if so how often. If it might change then you have to worry about keeping all copies of it up to date. It's also more space, but for an integer that's not really an issue.

    It looks like you'll only save yourself one joined table? Surely that wasn't much of a problem before.
  4. #3
  5. A Change of Season
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Mar 2004
    Location
    Next Door
    Posts
    3,536
    Rep Power
    221
    Things like this come up quite often. I usually take the path of least resistance.
    Got it.
    Right thing should be done.

IMN logo majestic logo threadwatch logo seochat tools logo