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

Create Database Table mapping release to puid that is populated by a trigger on new puids

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: High
    • Resolution: Won't Fix
    • Affects Version/s: NGS - Beta 3
    • Fix Version/s: NGS - Release Candidate 2
    • Component/s: Search
    • Labels:
      None

      Description

      Rob, a while ago we discussed doing this to improve the speed of building the search index so that it could easily get all the puids for a release without having to access track/recording/puid tables.

      We tried to improve the speed of indexing without doing this, this improved things a bit for you but actually made things worse in my setup, and the sensible thing to do is add this table it will improve the building of the index significantly.

        Attachments

          Activity

            People

            Assignee:
            rob Robert Kaye
            Reporter:
            ijabz Paul Taylor
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Packages

                Version Package
                NGS - Release Candidate 2