Changes between Initial Version and Version 1 of Ticket #19029, comment 2
- Timestamp:
- Sep 27, 2012, 7:32:27 AM (12 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #19029, comment 2
initial v1 1 I think we should leave the behavior as it is, you can use `Event.objects.filter(venue__city__in= list(cities))`if you want to prevent a subquery. If we change this behavior there is no easy way to get back to the current status without manually resetting the `_result_cache`. I also think that a subquery will usually perform better than putting a large list of numbers into the in-clause.1 I think we should leave the behavior as it is, you can use `Event.objects.filter(venue__city__in=cities.values_list(…))` if you want to prevent a subquery. If we change this behavior there is no easy way to get back to the current status without manually resetting the `_result_cache`. I also think that a subquery will usually perform better than putting a large list of numbers into the in-clause.