7270 2015-01-30 15:39:40 +0000 Make django use a single query on queries using foreign key 2015-04-30 14:35:04 +0000 1 1 7 Build System, Metadata & Runtime Toaster toaster unspecified x86 Multiple RESOLVED FIXED Medium enhancement Future 1 michael.g.wood alexandru.damian alexandru.damian belen.barros.pena bluelightning cristiana.voicu jessica.zhang --- --- No (bug/feature does not impact docs) oldest_to_newest 48439 0 michael.g.wood 2015-01-30 15:39:40 +0000 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 48894 1 alexandru.damian 2015-02-17 18:01:03 +0000 partially implemented in adamian/20150217_bug_7004 because of annoying issues when refreshing. 50646 2 alexandru.damian 2015-04-30 14:35:04 +0000 All identified performance bottlenecks due to multiple linked requests have been changed to select_related, or batched array-based selection, and patches merged.