Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Review and optimize monthly report generation (resource utilization) #3

Open
akomii opened this issue Nov 6, 2024 · 0 comments
Open

Review and optimize monthly report generation (resource utilization) #3

akomii opened this issue Nov 6, 2024 · 0 comments
Labels
enhancement New feature or request

Comments

@akomii
Copy link
Contributor

akomii commented Nov 6, 2024

Several sites are experiencing severe performance issues during monthly report generation:

  • CPU usage spikes up to 200%
  • DWH frontend becomes unresponsive
  • Incoming CDA imports fail due to "OutOfMemory" errors

A comprehensive review and optimization of the report generation process is required. Areas to investigate:

  1. End-to-end pipeline (UI implementation & Java backend processing)
  2. XML Schema efficiency
  3. SQL Query optimization

The goal is to reduce resource consumption and ensure stable operation of the DWH during report generation, preventing interference with other critical operations like CDA imports.
@akomii akomii added the enhancement New feature or request label Nov 6, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement New feature or request
Projects
AKTIN Project
Status: Todo
Milestone
No milestone
Development

No branches or pull requests
1 participant
@akomii