Opened 3 years ago

Last modified 3 years ago

#22115 new Bug

Related Querysets from Inlines not getting cached

Reported by: john.parton@… Owned by: nobody
Component: contrib.admin Version: 1.6
Severity: Normal Keywords: admin, inline, queryset, queryset caching
Cc: Triage Stage: Accepted
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no


Here's an overview of my code:

    from django.db import models

    class ExampleParent(models.Model):
        def __unicode__(self):
            return u'Example Parent: %s' %

    class ExampleInline(models.Model):
        parent = models.ForeignKey('ExampleParent')
        child = models.ForeignKey('ExampleChild')
        def __unicode__(self):
            return u'Example Inline: %s' %
    class ExampleChild(models.Model):
        def __unicode__(self):
            return u'Example Child: %s' %

    from django.contrib import admin

    from admin_issue.example_problem.models import (ExampleParent, ExampleInline)

    class ExampleInlineInline(admin.TabularInline):
        model = ExampleInline

    class ExampleParentAdmin(admin.ModelAdmin):
        inlines = [
        ], ExampleParentAdmin)

If you go to the admin details for an ExampleParent instance, a query will be executed to fetch all of ExampleChild for as many ExampleInlines are associated with that ExampleParent. These are exactly identical queries. I would expect each queryset to be cached and for the ORM.

I have a few models in production that produces hundreds (sometimes over a thousand) queries. Most of them are exactly identical queries that could be cached.

I could probably patch my code to work around this, but it seems like the expected default behavior would be to cache these.

I can generate a small project with a sqlite db if necessary.

John P.

Change History (1)

comment:1 Changed 3 years ago by Aymeric Augustin

Needs documentation: unset
Needs tests: unset
Patch needs improvement: unset
Triage Stage: UnreviewedAccepted

This makes sense. However, it might be prohibitively hard to implement.

Note: See TracTickets for help on using tickets.
Back to Top