limit number of db queries

diff --git a/qcg/views.py b/qcg/views.py
index fec0017..dab0a24 100644 (file)
--- 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))