From a58466aa69d7c78bb740d90a446bcc71898deb08 Mon Sep 17 00:00:00 2001 From: Maciej Tronowski Date: Tue, 8 Sep 2015 15:43:17 +0200 Subject: [PATCH] limit number of db queries --- qcg/views.py | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/qcg/views.py b/qcg/views.py index fec0017..dab0a24 100644 --- a/qcg/views.py +++ b/qcg/views.py @@ -166,14 +166,14 @@ def jobs_list(request): @restricted def job_details(request, job_id): - job = get_object_or_404(request.user.jobs.prefetch_related('tasks'), job_id=job_id) + job = get_object_or_404(request.user.jobs.select_related('owner').prefetch_related('tasks'), job_id=job_id) return render(request, 'qcg/job.html', process_details(request, job)) @restricted def task_details(request, job_id, task_id): - task = get_object_or_404(request.user.tasks.select_related('job').prefetch_related('allocations'), + task = get_object_or_404(request.user.tasks.select_related('job__owner').prefetch_related('allocations'), job__job_id=job_id, task_id=task_id) return render(request, 'qcg/task.html', process_details(request, task.job, task)) -- 1.7.9.5