Speed up fetching metarecord attributes for staff catalog and Staff View
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
New
|
Undecided
|
Unassigned |
Bug Description
This is a follow-up for bug 2051708.
Among other things, the method open-ils.
However, even with the improvements in bug 2051708, the metarecord attribute parsing adds a good 1-3 seconds for search results processing or Staff View display if one or more of the bibs being summarized is part of a metarecord set that has more than 100 members.
Some potential ways to improve performance include:
- Summarizing only the attributes that are actually needed for displays
- Not fetching metarecord member attributes when invoking open-ils.
- Writing a stored procedure to more efficiently summarize the attributes for the members of a metarecord
- Improving the algorithm used to produce the summary
Evergreen 3.11+
tags: | added: search staffcatalog |
A WIP patch to speed this up can be found the branch working/ collab/ gmcharlt/ lp2051726_ speed_up_ attr_fetch