Uploaded image for project: 'MusicBrainz Server'
  1. MusicBrainz Server
  2. MBS-12256

Keep rating and rating_count column on *_meta tables up-to-date with triggers

XMLWordPrintable

      To store the average rating and count of all ratings for an entity, we use two columns on the associated entity's *_meta table: rating and rating_count.  For example, artists have artist_meta.rating and artist_meta.rating_count.

      These columns are currently kept up-to-date by our code whenever a rating is added or updated.  This ticket proposes updating these columns with triggers instead, on the *_rating_raw tables (e.g. artist_rating_raw).

      This would have no effect on mirror servers, as triggers are generally not created there.

            bitmap Michael Wiencek
            bitmap Michael Wiencek
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:

                Version Package
                Schema change, 2022 Q2