This was observed in bugfest. Logs were having a lot of noise like below:
The logs for mod-inventory-storage are huge, therefore they can't be attached here. Please contact Zmiivska for logs if need be.
- the indexes are added
- the warnings are disappeared
UIIN-1062 - Bugfest: Inventory. Instance, holdings, item segment. Query search - poor response time (about a minute):
Overview: Query search in all three segments are very slow (poor performance) in Bugfest environment, compared to uChicago's environment (Edelweiss). The same search do also sometimes result in: 1000 records found - which is the new 999,999,999 records found.
Steps to reproduce:
- Login to the bugfest environment, go to inventory
- Select the Instance segment, and search option Query search
- When searching: publication = "MIT Press" - Search (https://bugfest.folio.ebsco.com/inventory?qindex=querySearch&query=publication%20%3D%20%22MIT%20Press%22&sort=Title)
I get my search result up quickly - in about > 1 sec (https://wiki.folio.org/pages/viewpage.action?pageId=25729156)
Some more Query search tests:
|Segment||Query search||Time log
|Instance||subjects = "history"||00:05 sec||35,813 records found|
|Instance||series = "cooperative information systems"||00:43 sec||7 records found|
|Holdings||holdingsRecords.callNumber = "HD1697.R9F79"||00:33 sec||1 record found|
|Holdings||holdingsRecords.holdingsStatements = "v.57:no.1-3"||00:16 sec||24 records found|
|Item||item.enumeration = "v.71"||00:08 sec||44,604 records found|
|Item||item.formerIds = "hzn64519"||00:37 sec||1 record found|
Query search fails when search using parentheses, e.g. in the holdingsRecords.holdingsStatements = ".57:no.1-3(2014:Jul-2015:Jan) - then following error message pop up:
I'll investigate this some more, and file another bug ticket for this.