What is the best way to store unique votes?
Posted: Sat Apr 09, 2011 2:26 pm
I'm designing a voting system and was wondering what the best method is for storing unique votes.
I remember a couple years back I used a simple table that stored ip_address and a post_id to record what user had viewed what page so they could not record multiple views from one IP. This method worked, but I remember page loads starting to become laggy as the table got bigger and bigger and I would have to search the table to make sure the person had not previously viewed the page.
So my question is, is there a better method for storing uniqueness? Facebook can do it with their Like button and that's everywhere
I remember a couple years back I used a simple table that stored ip_address and a post_id to record what user had viewed what page so they could not record multiple views from one IP. This method worked, but I remember page loads starting to become laggy as the table got bigger and bigger and I would have to search the table to make sure the person had not previously viewed the page.
So my question is, is there a better method for storing uniqueness? Facebook can do it with their Like button and that's everywhere