I am going to implement voting for posts. There are considered two variants:
For each post the user can vote once.
User has N (e.g. 15) votes per day and can vote from for up to 15 posts to for one post 15 times.
In the variant 2, I need to show user’s votes for each post, therefore read the DB for each displayed post (in a post stream similar to Twitter), with key combining user ID and post ID.
So, may the variant 2 tend to be too slow or to costly?