General tuning of Inventory search indexes pt2

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:



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

Priority

Fix versions

Development Team

Core: Platform

Assignee

Solution Architect

Parent Field Value

None

Parent Status

None

Checklist

hide

TestRail: Results

Activity

Show:
Done

Details

Reporter

Back End Estimate

XXL < 30 days

Back End Estimator

Rank: GBV (MVP Sum 2020)

R1

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs
Created January 15, 2019 at 3:05 PM
Updated September 16, 2020 at 9:12 PM
Resolved April 9, 2019 at 11:36 AM
TestRail: Cases
TestRail: Runs