Hi John, django-developers is for discussion of the development of Django itself. It isn't a second level support channel if your query on django-users goes unanswered. Thanks!
On Thursday, February 20, 2014 5:45:27 PM UTC-5, [email protected] wrote: > > 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 [email protected]. To post to this group, send email to [email protected]. 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/ee52c6e2-dd18-4262-9f18-c30b7348646b%40googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
