I want to introduce a Facebook-like "likes" system, in that my members can click a like (or dislike) button and it rates the post up or down. A tally of the likes should be visible.
My first (and only) thought of implementing this is to create a new "likes" table in my MySQL database. But when I look back on websites such as Facebook and YouTube, who have billions of likes for all of their videos, it seems resource consuming to have a table that may contain that many entries.
The structure of the table would be
id, post, value, user
Are there any alternatives to using a MySQL table for "likes" ?