Details

    • Type: Improvement Improvement
    • Status: Closed Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: Current Version
    • Fix Version/s: TAG 2015/16
    • Component/s: OIOIOI
    • Labels:

      Description

      (Probably a lot of work. Solving it reasonably likely requires drastic changes).

      The current ranking caching strategy is not suitable for contest with many (e.g > 1000) users. It takes around 30s to generate such a ranking and the current RANKING_CACHE_TIMEOUT is set to 30s. Increasing this constant will not solve the problem, as the ranking gets invalidated every time some new solution is judged.

      One of the possible solution could be introducing ranking_cache_timeout in the contest controller, for example 30 mins for contests with many users and 30s for ACM style contests. It is also worth considering to cache rankings separately for contest admins and regular contestants.

      This issue is related to displaying links to "my submissions" in the ranking view. Apparently they get broken when the ranking caching with large timeout is enabled. Maybe this feature should be disabled.

        Issue Links

          Activity

          Hide
          Gerrit Gerrit added a comment -
          Change I4264927896fda177f52420976e5b1a5c4d7bb722, patchset 1
          https://gerrit.sio2project.mimuw.edu.pl/2576

          SIO-1687 Prepare rankings app for integration with rankingsd

          Change-Id: I4264927896fda177f52420976e5b1a5c4d7bb722
          Show
          Gerrit Gerrit added a comment - Change I4264927896fda177f52420976e5b1a5c4d7bb722, patchset 1 https://gerrit.sio2project.mimuw.edu.pl/2576 SIO-1687 Prepare rankings app for integration with rankingsd Change-Id: I4264927896fda177f52420976e5b1a5c4d7bb722
          Hide
          Gerrit Gerrit added a comment -
          Change I4264927896fda177f52420976e5b1a5c4d7bb722, patchset 2
          https://gerrit.sio2project.mimuw.edu.pl/2576

          SIO-1687 Prepare rankings app for integration with rankingsd

          Change-Id: I4264927896fda177f52420976e5b1a5c4d7bb722
          Show
          Gerrit Gerrit added a comment - Change I4264927896fda177f52420976e5b1a5c4d7bb722, patchset 2 https://gerrit.sio2project.mimuw.edu.pl/2576 SIO-1687 Prepare rankings app for integration with rankingsd Change-Id: I4264927896fda177f52420976e5b1a5c4d7bb722
          Hide
          Gerrit Gerrit added a comment -
          Change I4264927896fda177f52420976e5b1a5c4d7bb722, patchset 3
          https://gerrit.sio2project.mimuw.edu.pl/2576

          SIO-1687 Prepare rankings app for integration with rankingsd

          Change-Id: I4264927896fda177f52420976e5b1a5c4d7bb722
          Show
          Gerrit Gerrit added a comment - Change I4264927896fda177f52420976e5b1a5c4d7bb722, patchset 3 https://gerrit.sio2project.mimuw.edu.pl/2576 SIO-1687 Prepare rankings app for integration with rankingsd Change-Id: I4264927896fda177f52420976e5b1a5c4d7bb722
          Hide
          Gerrit Gerrit added a comment -
          Change I4264927896fda177f52420976e5b1a5c4d7bb722, patchset 4
          https://gerrit.sio2project.mimuw.edu.pl/2576

          SIO-1687 Prepare rankings app for integration with rankingsd

          Change-Id: I4264927896fda177f52420976e5b1a5c4d7bb722
          Show
          Gerrit Gerrit added a comment - Change I4264927896fda177f52420976e5b1a5c4d7bb722, patchset 4 https://gerrit.sio2project.mimuw.edu.pl/2576 SIO-1687 Prepare rankings app for integration with rankingsd Change-Id: I4264927896fda177f52420976e5b1a5c4d7bb722
          Hide
          Gerrit Gerrit added a comment -
          Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 6
          https://gerrit.sio2project.mimuw.edu.pl/2577

          SIO-1687 rankingd implementation

          Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Show
          Gerrit Gerrit added a comment - Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 6 https://gerrit.sio2project.mimuw.edu.pl/2577 SIO-1687 rankingd implementation Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Hide
          Gerrit Gerrit added a comment -
          Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 7
          https://gerrit.sio2project.mimuw.edu.pl/2577

          SIO-1687 rankingd implementation

          Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Show
          Gerrit Gerrit added a comment - Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 7 https://gerrit.sio2project.mimuw.edu.pl/2577 SIO-1687 rankingd implementation Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Hide
          Gerrit Gerrit added a comment -
          Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 8
          https://gerrit.sio2project.mimuw.edu.pl/2577

          SIO-1687 rankingd implementation

          Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Show
          Gerrit Gerrit added a comment - Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 8 https://gerrit.sio2project.mimuw.edu.pl/2577 SIO-1687 rankingd implementation Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Hide
          Gerrit Gerrit added a comment -
          Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 9
          https://gerrit.sio2project.mimuw.edu.pl/2577

          SIO-1687 rankingd implementation

          Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Show
          Gerrit Gerrit added a comment - Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 9 https://gerrit.sio2project.mimuw.edu.pl/2577 SIO-1687 rankingd implementation Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Hide
          Gerrit Gerrit added a comment -
          Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 10
          https://gerrit.sio2project.mimuw.edu.pl/2577

          SIO-1687 rankingd implementation

          Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Show
          Gerrit Gerrit added a comment - Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 10 https://gerrit.sio2project.mimuw.edu.pl/2577 SIO-1687 rankingd implementation Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Hide
          Gerrit Gerrit added a comment -
          Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 11
          https://gerrit.sio2project.mimuw.edu.pl/2577

          SIO-1687 rankingd implementation

          Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Show
          Gerrit Gerrit added a comment - Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 11 https://gerrit.sio2project.mimuw.edu.pl/2577 SIO-1687 rankingd implementation Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Hide
          Gerrit Gerrit added a comment -
          Change Iac9ed7674b91e050fab5ba632fd7b889366773ff, patchset 7
          https://gerrit.sio2project.mimuw.edu.pl/2581

          SIO-1687 Integrate rankingd and refactor rankings module

          Change-Id: Iac9ed7674b91e050fab5ba632fd7b889366773ff
          Show
          Gerrit Gerrit added a comment - Change Iac9ed7674b91e050fab5ba632fd7b889366773ff, patchset 7 https://gerrit.sio2project.mimuw.edu.pl/2581 SIO-1687 Integrate rankingd and refactor rankings module Change-Id: Iac9ed7674b91e050fab5ba632fd7b889366773ff
          Hide
          Gerrit Gerrit added a comment -
          Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 12
          https://gerrit.sio2project.mimuw.edu.pl/2577

          SIO-1687 rankingsd implementation

          Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Show
          Gerrit Gerrit added a comment - Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 12 https://gerrit.sio2project.mimuw.edu.pl/2577 SIO-1687 rankingsd implementation Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Hide
          Gerrit Gerrit added a comment -
          Change Iac9ed7674b91e050fab5ba632fd7b889366773ff, patchset 8
          https://gerrit.sio2project.mimuw.edu.pl/2581

          SIO-1687 Integrate rankingd and refactor rankings module

          Change-Id: Iac9ed7674b91e050fab5ba632fd7b889366773ff
          Show
          Gerrit Gerrit added a comment - Change Iac9ed7674b91e050fab5ba632fd7b889366773ff, patchset 8 https://gerrit.sio2project.mimuw.edu.pl/2581 SIO-1687 Integrate rankingd and refactor rankings module Change-Id: Iac9ed7674b91e050fab5ba632fd7b889366773ff
          Hide
          Gerrit Gerrit added a comment -
          Change Iac9ed7674b91e050fab5ba632fd7b889366773ff, patchset 9
          https://gerrit.sio2project.mimuw.edu.pl/2581

          SIO-1687 Integrate rankingd and refactor rankings module

          Change-Id: Iac9ed7674b91e050fab5ba632fd7b889366773ff
          Show
          Gerrit Gerrit added a comment - Change Iac9ed7674b91e050fab5ba632fd7b889366773ff, patchset 9 https://gerrit.sio2project.mimuw.edu.pl/2581 SIO-1687 Integrate rankingd and refactor rankings module Change-Id: Iac9ed7674b91e050fab5ba632fd7b889366773ff
          Hide
          Gerrit Gerrit added a comment -
          Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 13
          https://gerrit.sio2project.mimuw.edu.pl/2577

          SIO-1687 rankingsd implementation

          Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Show
          Gerrit Gerrit added a comment - Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 13 https://gerrit.sio2project.mimuw.edu.pl/2577 SIO-1687 rankingsd implementation Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Hide
          Gerrit Gerrit added a comment -
          Change Iac9ed7674b91e050fab5ba632fd7b889366773ff, patchset 10
          https://gerrit.sio2project.mimuw.edu.pl/2581

          SIO-1687 Integrate rankingd and refactor rankings module

          Change-Id: Iac9ed7674b91e050fab5ba632fd7b889366773ff
          Show
          Gerrit Gerrit added a comment - Change Iac9ed7674b91e050fab5ba632fd7b889366773ff, patchset 10 https://gerrit.sio2project.mimuw.edu.pl/2581 SIO-1687 Integrate rankingd and refactor rankings module Change-Id: Iac9ed7674b91e050fab5ba632fd7b889366773ff
          Hide
          Gerrit Gerrit added a comment -
          Change Iac9ed7674b91e050fab5ba632fd7b889366773ff, patchset 11
          https://gerrit.sio2project.mimuw.edu.pl/2581

          SIO-1687 Integrate rankingd and refactor rankings module

          Change-Id: Iac9ed7674b91e050fab5ba632fd7b889366773ff
          Show
          Gerrit Gerrit added a comment - Change Iac9ed7674b91e050fab5ba632fd7b889366773ff, patchset 11 https://gerrit.sio2project.mimuw.edu.pl/2581 SIO-1687 Integrate rankingd and refactor rankings module Change-Id: Iac9ed7674b91e050fab5ba632fd7b889366773ff
          Hide
          Gerrit Gerrit added a comment -
          Change Iac9ed7674b91e050fab5ba632fd7b889366773ff, patchset 12
          https://gerrit.sio2project.mimuw.edu.pl/2581

          SIO-1687 Integrate rankingd and refactor rankings module

          Change-Id: Iac9ed7674b91e050fab5ba632fd7b889366773ff
          Show
          Gerrit Gerrit added a comment - Change Iac9ed7674b91e050fab5ba632fd7b889366773ff, patchset 12 https://gerrit.sio2project.mimuw.edu.pl/2581 SIO-1687 Integrate rankingd and refactor rankings module Change-Id: Iac9ed7674b91e050fab5ba632fd7b889366773ff
          Hide
          Gerrit Gerrit added a comment -
          Change Iac9ed7674b91e050fab5ba632fd7b889366773ff, patchset 13
          https://gerrit.sio2project.mimuw.edu.pl/2581

          SIO-1687 Integrate rankingd and refactor rankings module

          Change-Id: Iac9ed7674b91e050fab5ba632fd7b889366773ff
          Show
          Gerrit Gerrit added a comment - Change Iac9ed7674b91e050fab5ba632fd7b889366773ff, patchset 13 https://gerrit.sio2project.mimuw.edu.pl/2581 SIO-1687 Integrate rankingd and refactor rankings module Change-Id: Iac9ed7674b91e050fab5ba632fd7b889366773ff
          Hide
          Gerrit Gerrit added a comment -
          Change Iac9ed7674b91e050fab5ba632fd7b889366773ff, patchset 14
          https://gerrit.sio2project.mimuw.edu.pl/2581

          SIO-1687 Integrate rankingd and refactor rankings module

          Change-Id: Iac9ed7674b91e050fab5ba632fd7b889366773ff
          Show
          Gerrit Gerrit added a comment - Change Iac9ed7674b91e050fab5ba632fd7b889366773ff, patchset 14 https://gerrit.sio2project.mimuw.edu.pl/2581 SIO-1687 Integrate rankingd and refactor rankings module Change-Id: Iac9ed7674b91e050fab5ba632fd7b889366773ff
          Hide
          Gerrit Gerrit added a comment -
          Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 14
          https://gerrit.sio2project.mimuw.edu.pl/2577

          SIO-1687 rankingsd implementation

          Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Show
          Gerrit Gerrit added a comment - Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 14 https://gerrit.sio2project.mimuw.edu.pl/2577 SIO-1687 rankingsd implementation Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Hide
          Gerrit Gerrit added a comment -
          Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 15
          https://gerrit.sio2project.mimuw.edu.pl/2577

          SIO-1687 rankingsd implementation

          Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Show
          Gerrit Gerrit added a comment - Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 15 https://gerrit.sio2project.mimuw.edu.pl/2577 SIO-1687 rankingsd implementation Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Hide
          Gerrit Gerrit added a comment -
          Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 16
          https://gerrit.sio2project.mimuw.edu.pl/2577

          SIO-1687 rankingsd implementation

          Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Show
          Gerrit Gerrit added a comment - Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 16 https://gerrit.sio2project.mimuw.edu.pl/2577 SIO-1687 rankingsd implementation Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Hide
          Gerrit Gerrit added a comment -
          Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 17
          https://gerrit.sio2project.mimuw.edu.pl/2577

          SIO-1687 rankingsd implementation

          Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Show
          Gerrit Gerrit added a comment - Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 17 https://gerrit.sio2project.mimuw.edu.pl/2577 SIO-1687 rankingsd implementation Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Hide
          Gerrit Gerrit added a comment -
          Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 18
          https://gerrit.sio2project.mimuw.edu.pl/2577

          SIO-1687 rankingsd implementation

          Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Show
          Gerrit Gerrit added a comment - Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 18 https://gerrit.sio2project.mimuw.edu.pl/2577 SIO-1687 rankingsd implementation Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Hide
          Gerrit Gerrit added a comment -
          Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 19
          https://gerrit.sio2project.mimuw.edu.pl/2577

          SIO-1687 rankingsd implementation

          Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Show
          Gerrit Gerrit added a comment - Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 19 https://gerrit.sio2project.mimuw.edu.pl/2577 SIO-1687 rankingsd implementation Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Hide
          Gerrit Gerrit added a comment -
          Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 20
          https://gerrit.sio2project.mimuw.edu.pl/2577

          SIO-1687 rankingsd implementation

          Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Show
          Gerrit Gerrit added a comment - Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 20 https://gerrit.sio2project.mimuw.edu.pl/2577 SIO-1687 rankingsd implementation Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Hide
          Gerrit Gerrit added a comment -
          Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 21
          https://gerrit.sio2project.mimuw.edu.pl/2577

          SIO-1687 rankingsd implementation

          Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Show
          Gerrit Gerrit added a comment - Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 21 https://gerrit.sio2project.mimuw.edu.pl/2577 SIO-1687 rankingsd implementation Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Hide
          Gerrit Gerrit added a comment -
          Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 22
          https://gerrit.sio2project.mimuw.edu.pl/2577

          SIO-1687 rankingsd implementation

          Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Show
          Gerrit Gerrit added a comment - Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 22 https://gerrit.sio2project.mimuw.edu.pl/2577 SIO-1687 rankingsd implementation Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Hide
          Gerrit Gerrit added a comment -
          Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 23
          https://gerrit.sio2project.mimuw.edu.pl/2577

          SIO-1687 rankingsd implementation

          Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Show
          Gerrit Gerrit added a comment - Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 23 https://gerrit.sio2project.mimuw.edu.pl/2577 SIO-1687 rankingsd implementation Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Hide
          Gerrit Gerrit added a comment -
          Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 24
          https://gerrit.sio2project.mimuw.edu.pl/2577

          SIO-1687 rankingsd implementation

          Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Show
          Gerrit Gerrit added a comment - Change I65361d0b737276f851c985287f4a5595cd444b60, patchset 24 https://gerrit.sio2project.mimuw.edu.pl/2577 SIO-1687 rankingsd implementation Change-Id: I65361d0b737276f851c985287f4a5595cd444b60
          Hide
          Gerrit Gerrit added a comment -
          Change Iac9ed7674b91e050fab5ba632fd7b889366773ff, patchset 15
          https://gerrit.sio2project.mimuw.edu.pl/2581

          SIO-1687 Integrate rankingd and refactor rankings module

          Change-Id: Iac9ed7674b91e050fab5ba632fd7b889366773ff
          Show
          Gerrit Gerrit added a comment - Change Iac9ed7674b91e050fab5ba632fd7b889366773ff, patchset 15 https://gerrit.sio2project.mimuw.edu.pl/2581 SIO-1687 Integrate rankingd and refactor rankings module Change-Id: Iac9ed7674b91e050fab5ba632fd7b889366773ff
          Hide
          Gerrit Gerrit added a comment -
          Change Iac9ed7674b91e050fab5ba632fd7b889366773ff, patchset 16
          https://gerrit.sio2project.mimuw.edu.pl/2581

          SIO-1687 Integrate rankingd and refactor rankings module

          Change-Id: Iac9ed7674b91e050fab5ba632fd7b889366773ff
          Show
          Gerrit Gerrit added a comment - Change Iac9ed7674b91e050fab5ba632fd7b889366773ff, patchset 16 https://gerrit.sio2project.mimuw.edu.pl/2581 SIO-1687 Integrate rankingd and refactor rankings module Change-Id: Iac9ed7674b91e050fab5ba632fd7b889366773ff
          Hide
          Gerrit Gerrit added a comment -
          Change Iac9ed7674b91e050fab5ba632fd7b889366773ff, patchset 17
          https://gerrit.sio2project.mimuw.edu.pl/2581

          SIO-1687 Integrate rankingd and refactor rankings module

          Change-Id: Iac9ed7674b91e050fab5ba632fd7b889366773ff
          Show
          Gerrit Gerrit added a comment - Change Iac9ed7674b91e050fab5ba632fd7b889366773ff, patchset 17 https://gerrit.sio2project.mimuw.edu.pl/2581 SIO-1687 Integrate rankingd and refactor rankings module Change-Id: Iac9ed7674b91e050fab5ba632fd7b889366773ff
          Hide
          Gerrit Gerrit added a comment -
          Change Iac9ed7674b91e050fab5ba632fd7b889366773ff, patchset 18
          https://gerrit.sio2project.mimuw.edu.pl/2581

          SIO-1687 Integrate rankingd and refactor rankings module

          Change-Id: Iac9ed7674b91e050fab5ba632fd7b889366773ff
          Show
          Gerrit Gerrit added a comment - Change Iac9ed7674b91e050fab5ba632fd7b889366773ff, patchset 18 https://gerrit.sio2project.mimuw.edu.pl/2581 SIO-1687 Integrate rankingd and refactor rankings module Change-Id: Iac9ed7674b91e050fab5ba632fd7b889366773ff

            People

            • Assignee:
              Szymon Acedański
              Reporter:
              Bartosz Tarnawski
              TAG Developer:
              Adam Paszke
              TAG Reviewer:
              Stanisław Barzowski
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: