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

Edit queries for large collections time out

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2015-12-14
    • Component/s: Collections
    • Labels:
      None

      Description

      Currently, the edit history page for large collections (on the order of a few thousand releases) will time out and generate an ISE until the cache is warmed up for that query. As discussed on IRC, I did some profiling on this around the time it was implemented and the issue appeared at that time to be in the join to the edit table. As Ulrich pointed out, the query has since been modified to improve the query plan for this join, but the timeout issue persists.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              chirlu Ulrich Klauer
              Reporter:
              sean.burke Sean Burke
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Due:
                Created:
                Updated:
                Resolved:

                  Packages

                  Version Package
                  2015-12-14