[go: nahoru, domu]
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.

Sign up for GitHub

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

Jump to bottom

Fix DB crash due to timeout #1031

Merged
merged 9 commits into from
Nov 7, 2023
Merged

Fix DB crash due to timeout #1031

merged 9 commits into from
Nov 7, 2023

Commits on Nov 6, 2023

  1. Create index on assessment ID in submissions table 

    Improves read performance.
    @RichDom2185
    RichDom2185 committed Nov 6, 2023
    Configuration menu
    Copy the full SHA
    ea43351 View commit details
    Browse the repository at this point in the history

  2. Create separate view layer for grading summary

    @RichDom2185
    RichDom2185 committed Nov 6, 2023
    Configuration menu
    Copy the full SHA
    a4aed5a View commit details
    Browse the repository at this point in the history

  3. Move views under AdminGradingView

    @RichDom2185
    RichDom2185 committed Nov 6, 2023
    Configuration menu
    Copy the full SHA
    ab9ac01 View commit details
    Browse the repository at this point in the history

  4. Migrate to more optimised query 

    * Use subquery instead of join for answers
* Split main model query and view model generation
* Split queries into 3
* Use ORM where possible
    @RichDom2185
    RichDom2185 committed Nov 6, 2023
    Configuration menu
    Copy the full SHA
    97890a6 View commit details
    Browse the repository at this point in the history

  5. Fix typing

    @RichDom2185
    RichDom2185 committed Nov 6, 2023
    Configuration menu
    Copy the full SHA
    26c74ed View commit details
    Browse the repository at this point in the history

  6. Restore group filtering functionality

    @RichDom2185
    RichDom2185 committed Nov 6, 2023
    Configuration menu
    Copy the full SHA
    69040ac View commit details
    Browse the repository at this point in the history

  7. Update Avenger backlog notification workers 

    Fixes compatibilty with new function signature.
    @RichDom2185
    RichDom2185 committed Nov 6, 2023
    Configuration menu
    Copy the full SHA
    af5c9e1 View commit details
    Browse the repository at this point in the history

  8. Remove old query

    @RichDom2185
    RichDom2185 committed Nov 6, 2023
    Configuration menu
    Copy the full SHA
    7646767 View commit details
    Browse the repository at this point in the history

  9. Remove comment

    @RichDom2185
    RichDom2185 committed Nov 6, 2023
    Configuration menu
    Copy the full SHA
    b51a598 View commit details
    Browse the repository at this point in the history