Holdings View Very Slow to Load with Moderate to High Number of Holdings

Bug #1827096 reported by John Amundson
This bug affects 2 people
Affects Status Importance Assigned to Milestone

Bug Description

Evergreen 3.2.5
This did not seem to affect Evergreen 3.0

The initial load of Holdings View can be excruciatingly slow depending on the number of holdings belonging to the chosen org unit and its descendants. The load speed does not seem to be dependent on number of rows displayed.

Some timings:
150 copies: 55 seconds to load
3,000 copies: 30 minutes to load

These might seem like outlandishly high number of items for a library to own, but numbers like these are not uncommon on some periodical records. For example, one of our libraries has 10 branches, if each branch retains the last 2 years of a magazine, then the library owns 240 copies of the title.

At central site, we also need to access larger records for the entire consortium, and the higher the number of holdings on a record, the more implausible this becomes.

While the page is loading, there is no indicator that anything is happening. If you try to change the number of displayed rows while waiting, a "fake/incomplete" list will load. If you try to select anything from the fake list, all the rows will highlight and no actions can be accurately performed. I've attached a screenshot of this. Notice how there are no Owning libraries listed and the "Manage" buttons for alerts does not display correctly.

Revision history for this message
John Amundson (jamundson) wrote :
Revision history for this message
Beth Willis (willis-a) wrote :

EG 3.2.4

I'm seeing the same issue on our training system, though the time to load is not as slow as John has reported. Some sample timings:

 ~400 copies: 25 seconds
 ~900 copies: 56 seconds
~1300 copies: 78-84 seconds

I also see the "fake/incomplete" list loading when I change the number of rows to display while waiting for the holdings to load.

tags: added: performance
Andrea Neiman (aneiman)
tags: removed: webstaffclient
Changed in evergreen:
status: New → Confirmed
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.