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

Retrieving edit note recipients is slow

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 2016-06-06
    • None
    • None
    • None

      MBS-8720 was supposed to make this faster, and I guess it did, but it's still extremely slow. https://gist.github.com/mwiencek/7cdd04e18c343bca16d97ffc2b8b1929

      Changing a_ins_edit_note to not insert rows where edit.editor = edit_note.editor means we can get rid of the filter in Data::EditNote::find_by_recipient, nearly cutting the query time in half from what I observed. But that's even before deleting all the existing rows where that condition is true (count = 20885520). So I guess we should start there.

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

              Created:
              Updated:
              Resolved:

                Version Package
                2016-06-06