I posted this to Django users, but didn't get a response. I'd like to help
to resolve this issue if at all possible.
Previous post:
I have the Django admin configured with a TabularInline, and the inline
model has a ForeignKey reference to a third model. Every row in the inline
generates a new query to fetch all of the instances of the third model.
Here's an overview of my code:
# models.py
> from django.db import models
>
> class ExampleParent(models.Model):
>
> def __unicode__(self):
> return u'Example Parent: %s' % self.id
>
> class ExampleInline(models.Model):
> parent = models.ForeignKey('ExampleParent')
> child = models.ForeignKey('ExampleChild')
>
> def __unicode__(self):
> return u'Example Inline: %s' % self.id
>
> class ExampleChild(models.Model):
>
> def __unicode__(self):
> return u'Example Child: %s' % self.id
>
# admin.py
> 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 = [
> ExampleInlineInline
> ]
>
> admin.site.register(ExampleParent, ExampleParentAdmin)
>
If you create a bunch of ExampleInlines that reference and ExampleParent,
then go to that instance in the admin, you get QUERY = u'SELECT
"example_problem_examplechild"."id" FROM "example_problem_examplechild"' -
PARAMS = () for every ExampleInline referenced.
Shouldn't that query be cached by Django? Is that expected behavior? Is
there a way to force Django to use the cache for subsequent inlines?
I'm also experiencing a similar problem with a ManyToMany field. (But it
seems to generate even more queries that the ForeignKey)
Any help on this issue would be most appreciated.
Thanks,
John P.
--
You received this message because you are subscribed to the Google Groups
"Django developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-developers+unsubscr...@googlegroups.com.
To post to this group, send email to django-developers@googlegroups.com.
Visit this group at http://groups.google.com/group/django-developers.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-developers/139e1577-86b2-4d96-9da9-c62d3dba2c75%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
