Sormas-project: [EPIC] Improving time in navigating, visualizing, filtering and loading pages on the web

[bernardsilenou]

Feature Description

• This issue is experienced by users with many entities in the db (more than 300000) cases and contacts and when many users (5000) are using the system at the same time.
• Dashboard especially contact dashboard takes long to load (this is an old issue but is not solved)

Problem Description

• Navigation through the directories takes long: 20 - 30 seconds on average to move from one tab to the next
• Filters on contact and other directories also takes long
• Detailed case view even takes longer to load
• Selection on contact and surveillance dashboard takes long also. (this is an old issues)

Proposed Change

• We need to improve the lazy loading.
  Suggestion: Load only the first 20 cases and display directory to user while loading the others at back end. The search icon can be removed while the process is going on, but immediately show the top 20 records as soon as user click on a directory icon.
  

  Possible Alternatives

Additional Information

• These performance issues were reported by users with version 1,48.

[Iheanacho2027]

Thanks @bernardsilenou this is very important and highly needed in Nigeria

[JonasCir]

If the performance bottleneck shows up with many users navigating SORMAS concurrently as you said @bernardsilenou, then Vaadin might be to blame as the DOM for each client is generated on the server what will likely lead to degraded performance. Maybe another reason for #1406.

[MateStrysewske]

@JonasCir There are soooo many reasons for #1406 :)

[markusmann-vg]

• [ ] Setup of a test-environments with access to certain protocols with 300k+ cases and contacts #2886
• [ ] Check the impact on the performance when an import is running (KPI: proposal to be made)
• [ ] Get example imports without first name, last name to see, what data is included so that we can check
• [ ] improve duplicate detection and check for redundant duplicate-checks #2782

[bernardsilenou]

In the performance meeting today, the french team reported that there was a significant improvement with the navigation time with version 1,48,2. Only the dashboard tasks much time to load now. Nigeria is still on 1,46, so no feedback yet. I would not close this issue now since some of the information here may be useful for performance testing. I have added a new issue on dashboard performance only #3167