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

[John Amundson]

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.

[Beth Willis (willis-a)]

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.