I'm developing a system to allow users to vote on different subjects using a Yes / No / Maybe question set.
Each question will be weighted as 2 (Yes) / 0 (No)/ 1 (Maybe) NOTE(The users will be voting multiple times, potentially huge amounts)
My plan is to store the answers in a mysql db.
Do I store each vote separately? (ID/Vote/)
What is a proper query to tally the vote results?
What is the most efficient way to store and retrieve the results? Should I have a table that stores the vote scores?
分享 main reason you would need to do #1 is to ensure no duplicate voting (e.g. store IP address where each vote was cast with this record).
if your looking for great performance, you can do what digg.com (according to a lecture) does for some things of this nature. they store all votes in a memcached node with IP to prevent duplicates with an expiration of ~24 hrs. they then have a daemon/cron job come and tally the votes and store them in an aggregated format at the persistent/db layer.
分享
