Details
-
Task
-
Status: Closed (View Workflow)
-
P3
-
Resolution: Duplicate
-
None
-
None
-
customfield_11100 19765
-
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
- blocks
-
CQLPG-59 Get rid of the regexp indexes and queries
-
- Closed
-
-
MODINVSTOR-166 Analyze and optimize search indexes
-
- Closed
-
-
UXPROD-1136 General tuning of Inventory search indexes
-
- Closed
-
-
UXPROD-1427 General tuning of Inventory search indexes pt2
-
- Closed
-
- is blocked by
-
FOLIO-1757 Add a test case for instance identifier search
-
- Closed
-
-
FOLIO-1771 clean up and isolate tests
-
- Closed
-
- relates to
-
CQLPG-42 Array searches in the FT mode
-
- Closed
-
-
FOLIO-922 Searching in repeated fields (arrays) in PostgreSQL JSON records.
-
- Closed
-
-
MODINVSTOR-215 use sort or search index depending on the result size
-
- Closed
-
-
MODINVSTOR-266 Fix identifier search slowness due to mismatch between index and query
-
- Closed
-
-
RMB-380 implement new approach for searching array-of-strings and array-of-objects fields
-
- Closed
-
-
CQLPG-81 Redesign CQL to SQL generation
-
- Closed
-