Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2010
    Posts
    13

    Unanswered: when should I separate a field into a table of itself

    Hey all,

    I have a user where they can have a vanity url. For their vanity url, they can have categories and each of their categories can have posts,images, comments, etc.

    Up until this point, the vanity url gets written to a field called user_name in the users table. But the vanity url must be approved by admin before it can be accessible as a web page. So now that my vanity url requires a field of its own called approved which is boolean datatype, should I break it into its own table and have the users table linked to it or should I just create another field in users table for the boolean even though the booleon relates to the vanity url field not the user itself.

    Thanks for response.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    purists will want a new table
    pragmatists will want a new column added to users table
    end users won't know or care which choice is made
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Oct 2010
    Posts
    13
    thanks for response. I presume then there's no performance hit whichever route I go.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I presume then there's no performance hit whichever route I go.
    If anyone claims that one performs better than the other,
    I'd ask for a reproducible test case that supports the claim.
    I suspect that any difference disappears within roundoff error.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •