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