I have a single table that holds the following data columns:

id = Auto Increment
provider = Twitter or Facebook (depends what they use to login with)
uid = User ID
name = Their full name (e.g. Chris Burton)
image = Profile Image
link = Social network profile link

In that same table I also have the following columns

comment = Comment text
article_id = Article ID
date = Date of when comment was submitted

My question is, should I keep the user login data separate from my comment data? Or is it more efficient to keep it together?

1 Answer 1


Use separete tables. If one user can make comments on many articles you will have huge repeat of same information.

  • 1
    Good point. I think what I'll do is only insert the uid (User ID) for actual comments. This way I can keep a record of who is posting. Feb 4, 2014 at 7:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.