Hi there, i was in midst of starting new site and in that i wanted to put voting feature , something like http://Digg. So i was wondering that how does digg stores information about which user voted to which link and then not allowing them to vote again.
One option could be to create a vote table then store link-id and member-id in this table. Now when any user tries to vote again this table is checked for entry and then accordingly user is allowed or not.
But this method's major flaw(according to me) is that it would be pretty large table e.g if there are 1k articles and each has approx 10 votes. Then there would be 1k*10=10k, and seeing size of digg where there is around 250k links in 24hrs and based on 10 votes theory there would be 2,500,000 entries added each day.