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. Link to comment https://forums.phpfreaks.com/topic/131102-best-way-to-store-votes-by-user/ 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. Link to comment https://forums.phpfreaks.com/topic/131102-best-way-to-store-votes-by-user/#findComment-680705 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.