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

Open
opened 3 months ago by k2s · 0 comments
k2s commented 3 months ago

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
konrad added the
kind/bug
kind/feature
labels 3 months ago
Sign in to join this conversation.
No Milestone
No Assignees
1 Participants
Notifications
Due Date

No due date set.

Dependencies

No dependencies set.

Reference: vikunja/api#1188
Loading…
There is no content yet.