What is the most winning strategy for counting likes?

Question

MySQL

Actually the question of speed when counting likes. The structure is as follows: table images
imgid,
Likeup
likedown
Table likes
I'd
Userid
Up
Direction
Created
Imageid
Indexes are configured on all IDs
As a result, is it worth bothering by making a trigger to insert like and update roles in the images table or just select count on the result set with each request . Image datasets 1000+ likes for each up to 10000+ General table of likes 10M records

Answer 1

Winning for what? Of course, it's faster to get an int than to aggregate every time