Details
-
Task
-
Status: Closed (View Workflow)
-
P3
-
Resolution: Done
-
None
-
None
-
-
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:
- Investigation should be done in order to find out what modules uses this indexes.
- 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
- defines
-
UXPROD-3446 NFR: Data Import R2 2022 Morning Glory Technical, NFR, & Misc work
-
- Closed
-
- relates to
-
MODINVSTOR-925 Remove redundant inventory-storage GIN and full-text indexes
-
- Closed
-