Fulltext Search (UXPROD-1045)

[UXPROD-1427] General tuning of Inventory search indexes pt2 Created: 15/Jan/19  Updated: 16/Sep/20  Resolved: 09/Apr/19

Status: Closed
Project: UX Product
Components: None
Affects versions: None
Fix versions: Q1 2019
Parent: Fulltext Search

Type: New Feature Priority: P3
Reporter: Jakub Skoczen Assignee: Jakub Skoczen
Resolution: Done Votes: 0
Labels: NFR, suppress-from-capplan
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified

Issue links:
Blocks
is blocked by MODINVSTOR-163 queries involving contributors or sub... In Progress
is blocked by MODINVSTOR-166 Analyze and optimize search indexes Closed
is blocked by CQLPG-58 ID searches way too slow Closed
is blocked by CQLPG-59 Get rid of the regexp indexes and que... Closed
is blocked by CQLPG-61 Equals empty is not same as equals star Closed
is blocked by MODINVSTOR-181 Tune primary ID indexes Closed
is blocked by MODINVSTOR-182 analyze and optimize identifiers arra... Closed
is blocked by MODINVSTOR-184 Analyze filtering by resource type Closed
is blocked by MODINVSTOR-185 Analyze filtering by location Closed
is blocked by MODINVSTOR-188 Analyze and optimize filtering by lan... Closed
Cloners
clones UXPROD-1136 General tuning of Inventory search in... Closed
Epic Link: Fulltext Search
Back End Estimate: XXL < 30 days
Back End Estimator: Jakub Skoczen
Development Team: Core: Platform
Rank: GBV (MVP Sum 2020): R1

 Description   

Review of Inventory database index configuration and appropriate tuning for the following search and sort indexes:

1. Fulltext search for scalar fields:

  • title

2. Fulltext search for repeatable fields

  • creators
  • subjects

3. Identifier (exact) search fields:

  • instance ID
  • barcode (requires data join support)
  • identifiers (ISBN/ISSN)
  • language filter/facet
  • resource type filter/facet
  • location filter/facet (requires data join support)

This item is specific to Inventory but builds on general work in Q3 and Q4, namely:

UXPROD-1048 Closed
UXPROD-1049 Closed
UXPROD-1134 Closed

This is also related to general response performance tuning in FOLIO see:

UXPROD-752 Closed


Generated at Fri Feb 09 00:15:30 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.