At the moment, the Progress Bar block overview page builds by creating the progress bar for each student individually. That means it is hitting the same tables repeatedly for each student. This is quite inefficient.

Pagination has helped that a bit, but if a user attempts to see all students in a large course it will have a big performance impact.

There is a need to create queries for the overview page, based on the single bar queries, but allowing for multiple IDs to be searched at the same time and returning a set of results that can be checked when building the overview page.