Speed up fetching metarecord attributes for staff catalog and Staff View

Bug #2051726 reported by Galen Charlton
6
This bug affects 1 person
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.search.biblio.record.catalog_summary.staff fetches and summarizes the record attributes of all of the other members of the metarecord that the bib(s) passed to it belong to. At the moment, this is done to support the part of Staff View in the staff catalog that counts records in the metarecord by icon format and language.

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.search.biblio.record.catalog_summary.staff when displaying search results. On the one hand, those metarecord member attributes are not currently used in search results display. On the other hand, I can envision future enhancements where you might want them to add links to related records in the metarecord.
- 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+

Galen Charlton (gmc)
tags: added: search staffcatalog
Revision history for this message
Galen Charlton (gmc) wrote :

A WIP patch to speed this up can be found the branch working/collab/gmcharlt/lp2051726_speed_up_attr_fetch

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.