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

      Optimize DB queries. Especially cases where we make O(n) queries or we get a lot of data to use only a small part. May require refactoring or solving things differently (like changing rules of which contests to display).

        Activity

        Hide
        Gerrit Gerrit added a comment -
        Change I246941ec374b0af929be7db746c431ebd86466ea, patchset 6
        https://gerrit.sio2project.mimuw.edu.pl/2551

        SIO-1773 Optimize visible_contest database queries

        Reduce number of queries from linear in contest
        count to linear in number of RegistrationController
        subclasses.

        Change-Id: I246941ec374b0af929be7db746c431ebd86466ea
        Show
        Gerrit Gerrit added a comment - Change I246941ec374b0af929be7db746c431ebd86466ea, patchset 6 https://gerrit.sio2project.mimuw.edu.pl/2551 SIO-1773 Optimize visible_contest database queries Reduce number of queries from linear in contest count to linear in number of RegistrationController subclasses. Change-Id: I246941ec374b0af929be7db746c431ebd86466ea
        Hide
        Gerrit Gerrit added a comment -
        Change I246941ec374b0af929be7db746c431ebd86466ea, patchset 7
        https://gerrit.sio2project.mimuw.edu.pl/2551

        SIO-1773 Optimize visible_contest database queries

        Reduce number of queries from linear in contest
        count to linear in number of RegistrationController
        subclasses.

        Change-Id: I246941ec374b0af929be7db746c431ebd86466ea
        Show
        Gerrit Gerrit added a comment - Change I246941ec374b0af929be7db746c431ebd86466ea, patchset 7 https://gerrit.sio2project.mimuw.edu.pl/2551 SIO-1773 Optimize visible_contest database queries Reduce number of queries from linear in contest count to linear in number of RegistrationController subclasses. Change-Id: I246941ec374b0af929be7db746c431ebd86466ea
        Hide
        Gerrit Gerrit added a comment -
        Change I024574a164e7c4ec5668df05dd0bcf02eec8e8c6, patchset 1
        https://gerrit.sio2project.mimuw.edu.pl/2553

        SIO-1773 Simplify queries in visible_contests

        Otherwise Postgres doesn't optimize complex queries, so it's in
        fact faster to do several simple ones, rather than a big complex one.

        Change-Id: I024574a164e7c4ec5668df05dd0bcf02eec8e8c6
        Show
        Gerrit Gerrit added a comment - Change I024574a164e7c4ec5668df05dd0bcf02eec8e8c6, patchset 1 https://gerrit.sio2project.mimuw.edu.pl/2553 SIO-1773 Simplify queries in visible_contests Otherwise Postgres doesn't optimize complex queries, so it's in fact faster to do several simple ones, rather than a big complex one. Change-Id: I024574a164e7c4ec5668df05dd0bcf02eec8e8c6
        Hide
        Gerrit Gerrit added a comment -
        Change I024574a164e7c4ec5668df05dd0bcf02eec8e8c6, patchset 2
        https://gerrit.sio2project.mimuw.edu.pl/2553

        SIO-1773 Simplify queries in visible_contests

        Otherwise Postgres doesn't optimize complex queries, so it's in
        fact faster to do several simple ones, rather than a big complex one.

        Change-Id: I024574a164e7c4ec5668df05dd0bcf02eec8e8c6
        Show
        Gerrit Gerrit added a comment - Change I024574a164e7c4ec5668df05dd0bcf02eec8e8c6, patchset 2 https://gerrit.sio2project.mimuw.edu.pl/2553 SIO-1773 Simplify queries in visible_contests Otherwise Postgres doesn't optimize complex queries, so it's in fact faster to do several simple ones, rather than a big complex one. Change-Id: I024574a164e7c4ec5668df05dd0bcf02eec8e8c6
        Hide
        Gerrit Gerrit added a comment -
        Change I80e314753764b1f2719c48be1b8f8343b018864d, patchset 2
        https://gerrit.sio2project.mimuw.edu.pl/2574

        SIO-1773 Cache global messages

        Change-Id: I80e314753764b1f2719c48be1b8f8343b018864d
        Show
        Gerrit Gerrit added a comment - Change I80e314753764b1f2719c48be1b8f8343b018864d, patchset 2 https://gerrit.sio2project.mimuw.edu.pl/2574 SIO-1773 Cache global messages Change-Id: I80e314753764b1f2719c48be1b8f8343b018864d

          People

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

            Dates

            • Created:
              Updated:
              Resolved: