Django lazy QuerySet and pagination

by

If you want to see where are occurring, import django.db.connection and inspect queries

>>> from django.db import connection
>>> from django.core.paginator import Paginator
>>> queryset = Entry.objects.all()

Lets create the paginator, and see if any queries occur:

>>> paginator = Paginator(queryset, 10)
>>> print connection.queries 
[]

None yet.

>>> page = paginator.page(4)
>>> page
<Page 4 of 788>
>>> print connection.queries 
[{'time': '0.014', 'sql': 'SELECT COUNT(*) FROM `entry`'}]

Creating the page has produced one query, to count how many entries are in the queryset. The entries have not been fetched yet.

Assign the page’s objects to the variable ‘objects’:

>>> objects = page.object_list
>>> print connection.queries
[{'time': '0.014', 'sql': 'SELECT COUNT(*) FROM `entry`'}]

This still hasn’t caused the entries to be fetched.

Generate the HttpResponse from the object list

>>> response = HttpResponse(page.object_list)
>>> print connection.queries
[{'time': '0.014', 'sql': 'SELECT COUNT(*) FROM `entry`'}, {'time': '0.011', 'sql': 'SELECT `entry`.`id`, <snip> FROM `entry` LIMIT 10 OFFSET 30'}]

Finally, the entries have been fetched.

More Related Contents:

  1. How can I combine two or more querysets in a Django view?
  2. How do I do an OR filter in a Django query?
  3. How to filter empty or NULL names in a QuerySet?
  4. Custom QuerySet and Manager without breaking DRY?
  5. Why does django’s prefetch_related() only work with all() and not filter()?
  6. Select DISTINCT individual columns in django?
  7. _set in Django for a queryset
  8. Raw SQL queries in Django views
  9. How to limit queryset/the records to view in Django admin site?
  10. Django: implementing JOIN using Django ORM?
  11. Django – filtering on foreign key properties
  12. How to create a Django queryset filter comparing two date fields in the same model
  13. Django Queryset with filtering on reverse foreign key
  14. How to dynamically provide lookup field name in Django query? [duplicate]
  15. Django: ManyToMany filter matching on ALL items in a list
  16. Django query datetime for objects older than 5 hours
  17. Django, query filtering from model method
  18. Django: Does prefetch_related() follow reverse relationship lookup?
  19. django most efficient way to count same field values in a query
  20. Django Order By Date, but have “None” at end?
  21. Django query case-insensitive list match
  22. Django: __in query lookup doesn’t maintain the order in queryset
  23. Django queryset get exact manytomany lookup [duplicate]
  24. how to write a query to get find value in a json field in django
  25. Django Reverse with arguments ‘()’ and keyword arguments ‘{}’ not found
  26. Get the latest record with filter in Django
  27. Django – Highlight Navigation based on current page?
  28. Run custom admin command from view
  29. Alternative to the deprecated setup_environ() for one-off django scripts?
  30. GDAL in flexible environment

Leave a Comment