Done
Details
Details
Assignee
Michelle Suranofsky
Michelle SuranofskyReporter
Julian Ladisch
Julian LadischLabels
Priority
Development Team
EBSCO - FSE
RCA Group
Data related (ex. Can be detected with large dataset only)
TestRail: Cases
Open TestRail: Cases
TestRail: Runs
Open TestRail: Runs
Created November 22, 2022 at 12:29 PM
Updated November 22, 2022 at 1:58 PM
Resolved November 22, 2022 at 1:58 PM
Use the field match == operator, not the word match = operator when looking up menualblocks for a userId:
https://dev.folio.org/faqs/explain-cql/
Only the field match == operator has a database index:
https://github.com/folio-org/mod-feesfines/blame/v18.1.1/src/main/resources/templates/db_scripts/schema.json#L94-L104
Using the word match = operator results in a full table scan with bad performance when the the manualblocks table gets bigger.