Details

    • Type: Improvement Improvement
    • Status: New New
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: Near Future
    • Fix Version/s: None
    • Component/s: OIOIOI
    • Labels:
      None

      Description

      Affected changes:
      https://gerrit.sio2project.mimuw.edu.pl/#/c/3505/
      https://gerrit.sio2project.mimuw.edu.pl/#/c/3515/

      Problem:
      The database query is too heavy.

      TODO:
      Optimize the database query.

      Description:

      As for now user contests will be visible for all registered users.
      This is something we don't want. (The user contests should be visible only to people who visited them before)

      The changes above aim to resolve this issue. But there is a side effect.
      In the first change there is a query that is not optimized by django:
       "return Q(contestview__user=request.user)"

      This results in a very heavy query that needs to be improved before it can be submitted to master.

        Activity

        Connect your code to JIRA

        Link every code change to JIRA just by adding an issue keys in commit messages. Bridge the gap back to your source and know which changes fixed which JIRA issues.

        Git & Mercurial in the cloud

        Collaborate across unlimited private code repositories.

        Git behind the firewall

        Manage and collaborate on Git repositories behind a firewall.

        Browse and search code

        Browse, search, and track source code repositories.

          People

          • Assignee:
            Unassigned
            Reporter:
            Cezary Chodun
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated: