Details
-
Story
-
Status: Open (View Workflow)
-
P3
-
Resolution: Unresolved
-
CP: sprint 91
-
1
Description
Overview:
Currently doing an Instance subject search by any keyword in an environment that has over 1.5 million instances records takes more than 80 seconds to return. mod-inventory-storage log shows a warning for missing full-text index. When applying a subjects full text index to the {tenant}_mod_inventory_storage.instance table the response time improved dramatically to under 2 seconds.
Steps to Reproduce:
- Navigate to Inventory app
- On the left "Search & Filter", make sure "Instance" is selected
- Click on the first drop down to select "Subject" search option
- Enter a keyword to search.
- * Note that in a database with more than 1 million records it will take more than a minute for results to return.
Acceptance criteria:
- UI search using the search option: Subjects takes less than 2 sec.
Attachments
Issue Links
- relates to
-
MODINVSTOR-499 Add Index for Instances Full-text Subjects Search
-
- Closed
-
-
FOLIO-2573 Paused due to POC of Elastic Search. All Search Options Should be Supported by a Database Index
-
- Closed
-