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

Speed up Data::ReleaseGroup::has_by_track_artist

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Fixed
    • Icon: Normal Normal
    • Schema change, 2021 Q2
    • None
    • None
    • None

      The query this performs is inefficient because it requires a seq scan on release_group. It can easily be modified to avoid this. This would have a noticeable impact on artist pages having a large number of release groups, particularly VA.

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

              Created:
              Updated:

                Version Package
                Schema change, 2021 Q2