The SIO2 project
  1. The SIO2 project
  2. SIO-1773

DB optimization

        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

            Ascending order - Click to sort in descending order
            Stanisław Barzowski made changes -
            Field Original Value New Value
            Labels T2
            Fix Version/s TAG 2015/16 Sprint 2 [ 12401 ]
            Adam Paszke made changes -
            Assignee Stanisław Barzowski [ sbarzowski ]
            Adam Paszke made changes -
            TAG Reviewer Adam Paszke [ apaszke ]
            Adam Paszke made changes -
            Assignee Stanisław Barzowski [ sbarzowski ] Adam Paszke [ apaszke ]
            Hide
            Permalink
            Gerrit Gerrit added a comment -
            Change I246941ec374b0af929be7db746c431ebd86466ea, patchset 1
            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 1 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
            Permalink
            Gerrit Gerrit added a comment -
            Change I246941ec374b0af929be7db746c431ebd86466ea, patchset 2
            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 2 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
            Permalink
            Gerrit Gerrit added a comment -
            Change I246941ec374b0af929be7db746c431ebd86466ea, patchset 3
            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 3 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
            Permalink
            Gerrit Gerrit added a comment -
            Change I51d85ef0a0993b0173a4d08e9ad02380c8c28a21, patchset 1
            https://gerrit.sio2project.mimuw.edu.pl/2552

            SIO-1773 Add teacher's permission caching

            This query has been repeated ~7x with each request

            Change-Id: I51d85ef0a0993b0173a4d08e9ad02380c8c28a21
            Show
            Gerrit Gerrit added a comment - Change I51d85ef0a0993b0173a4d08e9ad02380c8c28a21, patchset 1 https://gerrit.sio2project.mimuw.edu.pl/2552 SIO-1773 Add teacher's permission caching This query has been repeated ~7x with each request Change-Id: I51d85ef0a0993b0173a4d08e9ad02380c8c28a21
            Hide
            Permalink
            Gerrit Gerrit added a comment -
            Change I51d85ef0a0993b0173a4d08e9ad02380c8c28a21, patchset 2
            https://gerrit.sio2project.mimuw.edu.pl/2552

            SIO-1773 Add teacher's permission caching

            This query has been repeated ~7x with each request

            Change-Id: I51d85ef0a0993b0173a4d08e9ad02380c8c28a21
            Show
            Gerrit Gerrit added a comment - Change I51d85ef0a0993b0173a4d08e9ad02380c8c28a21, patchset 2 https://gerrit.sio2project.mimuw.edu.pl/2552 SIO-1773 Add teacher's permission caching This query has been repeated ~7x with each request Change-Id: I51d85ef0a0993b0173a4d08e9ad02380c8c28a21
            Hide
            Permalink
            Gerrit Gerrit added a comment -
            Change I246941ec374b0af929be7db746c431ebd86466ea, patchset 4
            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 4 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
            Permalink
            Gerrit Gerrit added a comment -
            Change I246941ec374b0af929be7db746c431ebd86466ea, patchset 5
            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 5 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
            Permalink
            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
            Permalink
            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
            Permalink
            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
            Permalink
            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
            Permalink
            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
            Stanisław Barzowski made changes -
            Assignee Adam Paszke [ apaszke ] Szymon Acedański [ accek ]
            TAG Developer Adam Paszke [ apaszke ]
            Stanisław Barzowski made changes -
            Status New [ 10000 ] Resolved [ 5 ]
            Resolution Fixed [ 1 ]
            Adam Paszke made changes -
            Assignee Szymon Acedański [ accek ] Adam Paszke [ apaszke ]
            Adam Paszke made changes -
            Assignee Adam Paszke [ apaszke ] Szymon Acedański [ accek ]
            Szymon Acedański made changes -
            Fix Version/s TAG 2015/16 [ 12500 ]
            Fix Version/s TAG 2015/16 Sprint 2 [ 12401 ]
            Szymon Acedański made changes -
            Status Resolved [ 5 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times Last Executer Last Execution Date
            New New Resolved Resolved
            		84d 1h 3m 1 Stanisław Barzowski 2016-06-15 17:36
            Resolved Resolved Closed Closed
            		1014d 1m 1 Szymon Acedański 2019-03-26 16:38

              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: