Vikunja not ready for huge number of list and tasks becasue of inefficient queries #1188
Following problems were identified:
- the lists are not paginated on UI
- we need to add pagination
inqueries 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
Reference in New Issue
No description provided.
Delete Branch "%!s(<nil>)"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?