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

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

Labels Milestones

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