loculus-project / loculus

An open-source software package to power microbial genomic databases
https://loculus.org
GNU Affero General Public License v3.0
37 stars 2 forks source link

Review page takes 10+ seconds to load if there are 10k sequences to review #3269

Open corneliusroemer opened 1 day ago

corneliusroemer commented 1 day ago

We no longer have OOM (at least for 10k sequences) as mentioned here: https://github.com/loculus-project/loculus/issues/2881#issue-2550791971 but load times are still unacceptably long if there are thousands of sequences to review/approve (e.g. curators).

West Nile shows blank screen to superusers for 10+ seconds.

This wasn't fixed in #3031

The issue isn't that there are many request made. It's that the website server seems to block, waiting for stuff.

Maybe mitigating the stall is as simple as disabling SSR of this page?

corneliusroemer commented 1 day ago

Actually Fabian already made a similar issue way back: https://github.com/loculus-project/loculus/issues/1612

chaoran-chen commented 1 day ago

Should we then close this ticket and use #1612? I renamed the title of #1612 to be more clear about the impact of the slow endpoint.

corneliusroemer commented 20 hours ago

These are slightly different issues: Fabian talks about the backend endpoint and this here is about slowness of the website. They might be solved in one go because they are due to same root cause or they might be fixed independently.