Mutley Posted November 2, 2008 Share Posted November 2, 2008 I have a site where users can vote for articles. I would like to record every article that user votes, so you can simply go into their profile and see which articles they have voted on. How would I organise this? I was thinking of simply a row for each vote in a table, such as: voteID userID articleID time 1 43 9 135213512 2 12 3 135213512 But if there are hundreds of thousands of votes, wouldn't this stuff the database and become slow? Thanks, Nick. Quote Link to comment Share on other sites More sharing options...
paul2463 Posted November 2, 2008 Share Posted November 2, 2008 Because they are allowed to vote on many articles, you will need the 'VotedFor' table to bridge the 'many to many' gap between the 'users' and 'products' tables. IMHO you will have to take the hit on size. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.