Page load times increase as resource count increases

[adolski]

As an institution's resource count grows, responsiveness of certain signed-in-only pages degrades. This ticket will track the progress of a fix.

Steps taken so far:

• Removed the "most active users in my institution" panel on the dashboard; this required a very slow query.
• Removed the assessment score colored-disc icons in the left-hand menu. These are surprisingly expensive, but they may be able to be restored as other efficiencies are achieved.
• Omit item-type resources from the left-hand menu.
• Resources on the show-collection and show-location pages are rendered as a flat, paginated list of immediate children, rather than a tree.
• Other minor efficiency tweaks

All of this has made a major improvement across many of the pages, but some are still slow. Fortunately, there is more that can be done. Will post updates as they come.

[jhain]

thank you for looking into this alex. OSU (the ones who cited a problem with this) are an important and big user, i appreciate you trying to make their experience better.

[adolski]

More steps:

1. Rewrote resource tree queries to use native SQL -- much more efficient.
2. Simplified the left menu to only show repositories & locations. This is also usability-related in that large numbers of collections could overwhelm the menu.
3. The "Move Resource" panel now loads via XHR, making resource page loads much faster.
4. Resource assessment scores are cached in the database on save, making score calculations faster.
5. Each individual section of the web-based assessment report is loaded independently. Now all but the collections section load pretty quickly. That section is much faster than before but could still use some work.
6. Other minor efficiency tweaks here and there.