Django – limiting query results

by

Django querysets are lazy. That means a query will hit the database only when you specifically ask for the result.

So until you print or actually use the result of a query you can filter further with no database access.

As you can see below your code only executes one sql query to fetch only the last 10 items.

In [19]: import logging                                 
In [20]: l = logging.getLogger('django.db.backends')    
In [21]: l.setLevel(logging.DEBUG)                      
In [22]: l.addHandler(logging.StreamHandler())      
In [23]: User.objects.all().order_by('-id')[:10]          
(0.000) SELECT "auth_user"."id", "auth_user"."username", "auth_user"."first_name", "auth_user"."last_name", "auth_user"."email", "auth_user"."password", "auth_user"."is_staff", "auth_user"."is_active", "auth_user"."is_superuser", "auth_user"."last_login", "auth_user"."date_joined" FROM "auth_user" ORDER BY "auth_user"."id" DESC LIMIT 10; args=()
Out[23]: [<User: hamdi>]

More Related Contents:

  1. Hi I am new to Django Framework.getting error :No Module Named
  2. How to upload a file in Django? [closed]
  3. How do I do an OR filter in a Django query?
  4. Django rest framework, use different serializers in the same ModelViewSet
  5. How to express a One-To-Many relationship in Django?
  6. Setting the selected value on a Django forms.ChoiceField
  7. Load a Django template tag library for all views by default
  8. Output Django queryset as JSON
  9. Prevent Django SQLite db from being overwritten while pushing to Heroku
  10. Django: How can I call a view function from template?
  11. The right place to keep my signals.py file in a Django project
  12. How do you use the django-filter package with a list of parameters?
  13. How to Unit test with different settings in Django?
  14. django – why is the request.POST object immutable?
  15. Heroku – Handling static files in Django app
  16. django – get() returned more than one topic
  17. django: Purpose of django.utils.functional.SimpleLazyObject?
  18. Django, request.user is always Anonymous User
  19. Django migration error :you cannot alter to or from M2M fields, or add or remove through= on M2M fields
  20. Django CSRF framework cannot be disabled and is breaking my site
  21. django filter older than day(s)?
  22. django @login_required decorator for a superuser
  23. Override default Django translations
  24. What is the right way to validate if an object exists in a django view without returning 404?
  25. Authorization Credentials Stripped — django, elastic beanstalk, oauth
  26. Django Order By Date, but have “None” at end?
  27. Django query case-insensitive list match
  28. How to limit file types on file uploads for ModelForms with FileFields?
  29. Django: access the parent instance from the Inline model admin
  30. Django: Using F arguments in datetime.timedelta inside a query

Leave a Comment