Why does django’s prefetch_related() only work with all() and not filter()?

by

In Django 1.6 and earlier, it is not possible to avoid the extra queries. The prefetch_related call effectively caches the results of a.photoset.all() for every album in the queryset. However, a.photoset.filter(format=1) is a different queryset, so you will generate an extra query for every album.

This is explained in the prefetch_related docs. The filter(format=1) is equivalent to filter(spicy=True).

Note that you could reduce the number or queries by filtering the photos in python instead:

someAlbums = PhotoAlbum.objects.filter(author="Davey Jones").prefetch_related("photo_set")
for a in someAlbums:
    somePhotos = [p for p in a.photo_set.all() if p.format == 1]

In Django 1.7, there is a Prefetch() object that allows you to control the behaviour of prefetch_related.

from django.db.models import Prefetch

someAlbums = PhotoAlbum.objects.filter(author="Davey Jones").prefetch_related(
    Prefetch(
        "photo_set",
        queryset=Photo.objects.filter(format=1),
        to_attr="some_photos"
    )
)
for a in someAlbums:
    somePhotos = a.some_photos

For more examples of how to use the Prefetch object, see the prefetch_related docs.

More Related Contents:

  1. Select DISTINCT individual columns in django?
  2. Django: implementing JOIN using Django ORM?
  3. Django Aggregation: Summation of Multiplication of two fields
  4. How to filter empty or NULL names in a QuerySet?
  5. How to view corresponding SQL query of the Django ORM’s queryset?
  6. Custom QuerySet and Manager without breaking DRY?
  7. Raw SQL queries in Django views
  8. How to limit queryset/the records to view in Django admin site?
  9. Django – filtering on foreign key properties
  10. How to query Case-insensitive data in Django ORM?
  11. Django: ManyToMany filter matching on ALL items in a list
  12. Django query datetime for objects older than 5 hours
  13. Django: Does prefetch_related() follow reverse relationship lookup?
  14. django most efficient way to count same field values in a query
  15. Django Order By Date, but have “None” at end?
  16. Django queryset get exact manytomany lookup [duplicate]
  17. Creating Partial Indexes with Django 1.7
  18. how to write a query to get find value in a json field in django
  19. When saving, how can you check if a field has changed?
  20. How to express a One-To-Many relationship in Django?
  21. How to create an object for a Django model with a many to many field?
  22. Setting the selected value on a Django forms.ChoiceField
  23. Django: Set foreign key using integer?
  24. _set in Django for a queryset
  25. Django Blob Model Field
  26. How to add data into ManyToMany field?
  27. Django model: delete() not triggered
  28. django-orm case-insensitive order by
  29. Django: dynamic database file
  30. How to delete a record in Django models?

Leave a Comment