App name/area of issue: Inventory (Search and filter)
Brief statement of issue: Filtering on Item status
- Note:* This issue was observed in bugfest fameflower. Filtering items by status is either slow or sometimes even hangs up the DB
How many users at any given time: This is a search with a staff user probably never would do intentionally, but it could happen by accident.
Volume of data: Gigantic search, if the tenant is a large library as uChicago (approximately: 10 mio item records)
Expected response time:
Outline steps for test:
- Login to bugfest, go to Inventory
- In the Search and filter pane, then select the Item segment
- When setting check mark in the Item status filter: "Available"
This is the query that was observed to take the longest time:
The same search in FOLIO Snapshot is: https://folio-snapshot.aws.indexdata.com/inventory?filters=itemStatus.Available&segment=items&sort=Title