-
Committer:
Dylan McCall
-
Date:
2010-06-23 03:14:51 UTC
-
Revision ID:
dylanmccall@gmail.com-20100623031451-5t8ac1dcjr341vrv
Tinkering with QuerySet stuff for performance.
opportunities_list QuerySet is filtered by selected packages in all cases again. (Filter added when it is first created in views.py).
Filtering alone (not counting display of package info) is down to 4 SQL queries total in all cases; one database hit for each model. Still feels heavy and needs some tuning, but it is balanced. Biggest possible query still takes 5 seconds of CPU time, but it no longer kills the server.