Vikunja not ready for huge number of list and tasks becasue of inefficient queries #1188

New Issue

k2s · 2022-06-19T18:53:20Z

k2s commented

2022-06-19 18:53:20 +00:00

Use my DB generator or download pre-generated database (99MB, >90.000 lists, >600.000 tasks).

Following problems were identified:

the lists are not paginated on UI
- we need to add pagination
DB in queries are not optimised and fail on huge datasets
- they should be rewritten to subqueries

Use my [DB generator](https://kolaente.dev/k2s/populate-vikunja) or download [pre-generated database](https://drive.google.com/file/d/1QTmqzUfep5vT3VgS_RraaBUtAMoFyV7D/view?usp=sharing) (99MB, >90.000 lists, >600.000 tasks). Following problems were identified: * the lists are not paginated on UI * we need to add pagination * DB `in` queries are not optimised and fail on huge datasets * they should be rewritten to subqueries

k2s referenced this issue

2022-06-19 19:02:17 +00:00

addListDetails was not optimized to build unique list of list owners #1189

konrad added the

kind/bug

kind/feature

labels 2022-06-19 21:09:53 +00:00

Sign in to join this conversation.