Skip to content
GitLab
Projects Groups Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in
  • Genesys Backend Genesys Backend
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 28
    • Issues 28
    • List
    • Boards
    • Service Desk
    • Milestones
  • Deployments
    • Deployments
    • Releases
  • Packages and registries
    • Packages and registries
    • Container Registry
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • Repository
  • Wiki
    • Wiki
  • Activity
  • Graph
  • Create a new issue
  • Commits
  • Issue Boards
Collapse sidebar
  • Genesys PGRGenesys PGR
  • Genesys BackendGenesys Backend
  • Issues
  • #636
Closed
Open
Issue created Mar 25, 2022 by Matija Obreza@mobrezaOwner

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.

Assignee
Assign to
Time tracking