Uploaded image for project: 'mod-inventory-storage'
  1. mod-inventory-storage
  2. MODINVSTOR-182

analyze and optimize identifiers array indexes (ISBN, ISSN, LCCN, OCLC, …)

    XMLWordPrintable

    Details

    • Template:
    • Development Team:
      Core: Platform

      Description

      Identifiers are kept in an array, each element having an identifier type id (UUID that points to an identifierType that has a name like 'ISBN'), and a value.

      Acceptance criteria:

      • provide schema.json entries that should be used for creating applicable indexes for identifier type fields
      • PG query explain should clearly show index in use
      • perform performance testing for CQL queries
        • (identifiers adj "\"value\": \"40*\"") sortby title
        • identifiers == "*\"value\": \"40*\", \"identifierTypeId\": \"8261054f-be78-422d-bd51-4ed9f33c3422\"*" sortby title

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                adam Adam Dickmeiss
                Reporter:
                heikki Heikki Levanto
                Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases