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

Speed up Data::ReleaseGroup::has_by_track_artist

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: Schema change, 2021 Q2
    • Component/s: None
    • Labels:
      None

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated:

                  Packages

                  Version Package
                  Schema change, 2021 Q2