Download MCPD

Generating MCPD can take quite a while with the current implementation. The main performance bottleneck in generating MCPD Excel rows are the subqueries to fetch properties with @ElementCollection.

For each Accession this requires a separate query to the database and this number of queries is the main bottleneck. You can inspect the number of queries by enabling hibernate SQL logging.

In this ticket we develop and implement a more efficient way of generating Excel rows for MCPD.