When we're querying the db and we want to access items from their foreign key e.g. Layer_Version.Layer if we use 'select_related' which tells django that we're going to need the items in the foreign table then it's able to do a inner join instead of running a lookup query for each item. https://docs.djangoproject.com/en/1.7/ref/models/querysets/#select-related I implemented this in the error-report-web and it's a big performance win when returning larger data sets
partially implemented in adamian/20150217_bug_7004 because of annoying issues when refreshing.
All identified performance bottlenecks due to multiple linked requests have been changed to select_related, or batched array-based selection, and patches merged.