Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Slowness when filtering on dates in statistics page #72

Closed
Elthan opened this issue Aug 21, 2018 · 2 comments
Closed

Slowness when filtering on dates in statistics page #72

Elthan opened this issue Aug 21, 2018 · 2 comments
Milestone

Comments

@Elthan
Copy link
Contributor

Elthan commented Aug 21, 2018

When filtering large amounts of assignments in the statistics page it takes a long time to load the page.
Implementing a better or faster way to filter by dates would decrease the server load.

@torgeirl
Copy link
Contributor

When filtering large amounts of assignments in the statistics page it takes a long time to load the page.

As an example, selecting assignment on a big course (800+ assignments) with many students can take appx 60s in the current production environment ((...)/statistics/?from=2021-01-01&to=2021-02-28). The same task will take appx 50s in our current development environment using v3.0.0b13 (if gateway timeout is increased from the default 30s).

@torgeirl torgeirl added this to the Trix 3.1 milestone Dec 19, 2022
@torgeirl torgeirl modified the milestones: Trix 4.0, Trix 4.1 Nov 29, 2023
@torgeirl torgeirl removed this from the Trix 4.1 milestone Jan 5, 2024
@Levijatan
Copy link
Collaborator

Started working on this before it was removed from the 4.1 milestone, and I have gotten it from about 5000-7000ms down to about 600ms in local testing for course with 800 assignments and 30 students with 10 bymyself, 10 withhelp, and 10 notsolved per assignment. Pushed up in bac3ced.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants