Looking to Build Module Limiting Votes in 24 hrs?

[Ascendancy]

I'm looking to create a small module which restricts the amount of votes a user can cast in 24 hours. Instead of pulling a new MySQL query every time the user votes I'd like to have some local caching system where it checks and stores each vote the user gives, and can then limit them if they pass before 24 hours is up. What would be the best way to cache this data?

Should I just pull from the database with every vote? This was my original idea, check the function each time a user casts a vote to see if they've exhausted their limit. But then I don't know if it's better to build a whole new d/b table for this info.

[Yankidank]

I'm not so great with MySQL optimizations, so I wouldn't be the best person to answer this. I think that the number of users you are dealing with and the amount of traffic would need to be considered. If your site doesn't have a ton of traffic then the advantages of doing some more advanced data caching are pretty negligible. In most website's cases I imagine that pulling the data from a database with every vote would be acceptable without having much of a performance hindrance.

[Ascendancy]

I'm not so great with MySQL optimizations, so I wouldn't be the best person to answer this. I think that the number of users you are dealing with and the amount of traffic would need to be considered. If your site doesn't have a ton of traffic then the advantages of doing some more advanced data caching are pretty negligible. In most website's cases I imagine that pulling the data from a database with every vote would be acceptable without having much of a performance hindrance.

Thanks man I appreciate the input. The site only runs a total of ~850 members and I'm thinking maybe 1/3 are truly active... so it'll probably be fine.