Uploaded image for project: 'mod-data-import'
  1. mod-data-import
  2. MODDATAIMP-679

Check possibility to remove redundant inventory-storage GIN and full-text indexes

    XMLWordPrintable

Details

    • Folijet Sprint 139
    • 2
    • Folijet
    • Morning Glory (R2 2022)

    Description

      Purpose/Overview:

      The migration process (updating all records in instances table) takes 8+ hours. Without indexes and triggers it takes ~ 30 mins.

      Requirements/Scope:

      1. Investigation should be done in order to find out what modules uses this indexes.
      2. The redundant indexes should be removed from redundant schema json.

      The following indexes are supposed to be removed:

      For Instance:

      • title
      • indexTitle
      • contributors
      • subjects
      • classifications
      • keyword
      • allTitles
      • contributorsNames
      • languages
      • dateOfPublication
        NB: The identifiers full-text index is retained. It means that ISBN and normalized ISBN search in inventory will work.

      For holdings:

      • electronicAccess
      • callNumberAndSuffixNormalized
      • fullCallNumberNormalized

      For item:

      • status.name
      • callNumberAndSuffixNormalized
      • fullCallNumberNormalized

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                Aivar Iusupov Aivar Iusupov
                Aivar Iusupov Aivar Iusupov
                Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases