Details
-
Type: Improvement
-
Status: New
-
Priority: 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.
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
- All
- Comments
- History
- Activity
- Transitions
- Commits