存储标签值以显示内容

Question

I have 150+ tags (more in future), 18000+ of different content to display and 380+ users (more in future).

What will be the best way to display content to users according to the Tag value for the user?

I thought of storing all tag activities in the database like:

 ________________________________
| Sr. | User_Id | Tag_Id | Int.  |
|________________________________|
| 1   | 152     | 18     | 15    |
| 2   | 152     | 24     | 8     |
| 3   | 18      | 127    | 4     |
|________________________________|

In database Int. means how many times the user is interested in the posts having Tag_Id.

As the user clicks <kbd>Interested?</kbd> the Int. column will be +1 for that user and that tag.

If I store the values in the database, the database will have huge content and huge traffic and will need large storage too. (108K values only for now then imagine the stage of values after 2 years.)

Any other best alternatives?

I am using PHP & MySQL.

Answer 1

For the best RM model solution, you will have to give some more information about the complete model. But as I see it now, this is the best solution. You can remove the id and set the primary key to user_id and tag_id (both).