Performance issue #336

New issue

Closed

opened 2024-11-22 12:31:41 +01:00 by hansegucker · 4 comments

hansegucker commented

2024-11-22 12:31:41 +01:00

Owner

    @staticmethod
    def resolve_notes_with_extra_mark(root: ParticipationStatus, info, **kwargs):
        return NewPersonalNote.objects.filter(
            person=root.person,
            documentation=root.related_documentation,
            extra_mark__isnull=False,
        )

    @staticmethod
    def resolve_notes_with_note(root: ParticipationStatus, info, **kwargs):
        return NewPersonalNote.objects.filter(
            person=root.person,
            documentation=root.related_documentation,
            note__isnull=False,
        ).exclude(note="")

Move to documentation, permission check, use prefetch_related/optimizer, filter in frontend
try to annotate permission checks
Remove canDelete from query

       existing_documentations = Documentation.objects.filter(
            datetime_start__lte=datetime_end,
            datetime_end__gte=datetime_start,
            amends__in=[e["REFERENCE_OBJECT"] for e in events],
        ).prefetch_related("participations")

Prefetch participations__person and participations__absence_reason

``` @staticmethod def resolve_notes_with_extra_mark(root: ParticipationStatus, info, **kwargs): return NewPersonalNote.objects.filter( person=root.person, documentation=root.related_documentation, extra_mark__isnull=False, ) @staticmethod def resolve_notes_with_note(root: ParticipationStatus, info, **kwargs): return NewPersonalNote.objects.filter( person=root.person, documentation=root.related_documentation, note__isnull=False, ).exclude(note="") ``` - [x] Move to documentation, permission check, use `prefetch_related`/optimizer, filter in frontend - [ ] try to annotate permission checks - [x] Remove `canDelete` from query ```python existing_documentations = Documentation.objects.filter( datetime_start__lte=datetime_end, datetime_end__gte=datetime_start, amends__in=[e["REFERENCE_OBJECT"] for e in events], ).prefetch_related("participations") ``` - [x] Prefetch `participations__person` and `participations__absence_reason`

Rows
Columns