What is the best way to store the overall rating of a material based on the rating of comments in Wordpress?

Question

WordPress

There is a feedback system, which is the usual comments with 3 additional fields for evaluation (each parameter can be rated for a maximum of 5 stars). A post has 4 ratings, the average rating for these three dimensions from the comments, and the overall rating, which is the arithmetic average of these three.
For clarity:
Post #1
--Convenience
--Quality --Price
--Overall
rating
Общий рейтинг = (Удобство + Качество + Цена) / 3
Convenience, Quality and Price are collected from the corresponding fields in the comments (we take get_comments()all the comments for each post as a function, run through the cycle, sum up all the parameters and divide by the number of - in the comments).
This is about calculations. What am I doing now. In the single.php itself, these actions are performed for me:

$comments  = get_comments(array(
            'post__in' => $post->ID));
          $comments_count = 0;
          $price = 0;
          $quality = 0;
          $service = 0;
          foreach ($comments as $comment) {
            $comment_id = $comment->comment_ID;
            $price_rating = (int)get_comment_meta( $comment_id, 'price_rating', true );
            $quality_rating = (int)get_comment_meta( $comment_id, 'quality_rating', true );
            $service_rating = (int)get_comment_meta( $comment_id, 'service_rating', true );
            $price +=$price_rating;
            $quality +=$quality_rating;
            $service +=$service_rating;
            $comments_count++;
          }

          // Average ratings
          $price_rating = ($comments_count > 0) ? $price/$comments_count : 0;
          $quality_rating = ($comments_count > 0) ? $quality/$comments_count : 0;
          $service_rating = ($comments_count > 0) ? $service/$comments_count : 0;

          $overall_rating = ($price_rating+$quality_rating+$service_rating) / 3;

That is, the overall rating of the post itself is not stored anywhere, it is only calculated each time.
But I have this rating should also be shown in short news. Therefore, I want to store this rating, that is, when adding a comment, attach it to the hook and update the overall rating of the post. Is this correct or should this problem be solved differently?

Answer 1

Why not record the rating in the post meta and update it when a new comment arrives, keeping track of the comment_post action?