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

Add a materialized view of edit note recipients

    XMLWordPrintable

    Details

      Description

      The new "Notes left on my edits" page (MBS-8676) performs badly and only became feasible by restricting it to edit notes from the last three months. The reason for this is that the "recipient" of the edit note, i.e. the editor who made the edit, is only available in the edit table, requiring a complete join with edit_note.

      To improve the performance, we would need some kind of "two-table index" which isn't possible. Instead, we sh to add a materialized view storing the "recipient" for every edit note, i.e. (recipient_editor_id, edit_note_id), with an index on recipient_editor_id; a trigger operating on inserts into edit_note would be enough to keep it updated.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                roman Roman
                Reporter:
                chirlu Ulrich Klauer
              • Votes:
                1 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved:

                  Packages

                  Version Package
                  Schema change, 2016-05-23