vikunja/vikunja
8
54
Fork 94
Code Issues 130 Pull Requests 35 Packages Releases 37 Activity

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

New Issue
Closed
opened 2022-06-19 18:53:20 +00:00 by k2s · 2 comments
k2s commented 2022-06-19 18:53:20 +00:00
Contributor
Copy Link

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 2022-06-19 21:09:53 +00:00
konrad commented 2024-12-13 16:18:17 +00:00
Owner
Copy Link

Is this still a problem?

Is this still a problem?
executed commented 2025-03-05 00:45:29 +00:00
Copy Link
  1. lists are definitely paginated on UI now.
  2. DB in queries are not optimised and fail on huge datasets - haven't tested this out.
    1000-2000 tasks in List view with pagination of 50 tasks per page feels responsive.
1. lists are definitely paginated on UI now. 2. DB in queries are not optimised and fail on huge datasets - haven't tested this out. 1000-2000 tasks in List view with pagination of 50 tasks per page feels responsive.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
dependencies
duplicate
This issue or pull request already exists
help wanted
Need some help
invalid
Something is wrong
kind/bug
Something is not working
kind/feature
New feature
needs reproduction
question
More information is needed
security
wontfix
This won't be fixed
No Label
kind/bug
kind/feature
Milestone
No items
No Milestone
Assignees
Clear assignees
dpschen frederick konrad renovate shilch
No Assignees
3 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: vikunja/vikunja#1188
No description provided.
Delete Branch "%!s()"

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?