Caching query results in django

by

Pop your cached query into Django’s cache:

from django.core.cache import cache

cache.set('key', queryset)

Then create a context processor to add the value of the cache to all templates:

# myproject/myapp/context_processors.py

from django.core.cache import cache

def cached_queries():
    return {'cache', cache.get('key')}

Then add your context processor in your Django settings file:

TEMPLATE_CONTEXT_PROCESSORS += (
    'myproject.myapp.context_processors.cached_queries'
)

Now you will be able to access the cache variable in all generic templates and all templates which have a requests context, which a template is given if this is done in the view:

return render_to_response('my_template.html',
                          my_data_dictionary,
                          context_instance=RequestContext(request))

When to Set the Cache

It depends on what is contained in the cache. However a common problem is that Django only really gets to execute Python whenever a page request is sent, and this is often not where you want to do this kind of work.

An alternative is to create a custom management command for a particular app. You can then either run this manually when necessary, or more commonly set this to run as a cron job.

To create a management command you must create a class decended from Command inside of a management/commands directory located inside of an app:

# myproject/myapp/management/commands/update_cache.py

from django.core.management.base import NoArgsCommand
from django.core.cache import cache

class Command(NoArgsCommand):
    help = 'Refreshes my cache'

    def handle_noargs(self, **options):
        cache.set('key', queryset)

The name of this file is important as this will be the name of the command. In this case you can now call this on the command line:

python manage.py update_cache

More Related Contents:

  1. Fighting client-side caching in Django
  2. log all sql queries
  3. How to define two fields “unique” as couple
  4. How to resolve “django.core.exceptions.ImproperlyConfigured: Application labels aren’t unique, duplicates: foo” in Django 1.7?
  5. How to filter empty or NULL names in a QuerySet?
  6. How to view corresponding SQL query of the Django ORM’s queryset?
  7. In a django model custom save() method, how should you identify a new object?
  8. Unique fields that allow nulls in Django
  9. How to use the request in a ModelForm in Django
  10. Django – iterate number in for loop of a template
  11. Inline Form Validation in Django
  12. Django Template – Increment the value of a variable
  13. How to deploy an HTTPS-only site, with Django/nginx?
  14. Make sure only one worker launches the apscheduler event in a pyramid web app running multiple workers
  15. Django: Validate file type of uploaded file
  16. Django data migration when changing a field to ManyToMany
  17. CSRF Failed: CSRF token missing or incorrect
  18. Django, SESSION_COOKIE_DOMAIN with multiple domains
  19. Organizing Django unit tests
  20. Django templates: value of dictionary key with a space in it
  21. Django removing object from ManyToMany relationship
  22. Nginx connection reset, response from uWsgi lost
  23. Log in / Sign up directly on home page
  24. Django model with 2 foreign keys from the same table
  25. What is the best way to store password in database when API call requires sending of password in plain text?
  26. Django Programming error column does not exist even after running migrations
  27. Django – Static file not found
  28. Different db for testing in Django?
  29. CSRF verification failed. Request aborted. on django
  30. django: how to access current request user in ModelForm?

Leave a Comment