#13118: Multiple(minimum 36) queries when opening user page in django admin -------------------------------------------+-------------------------------- Reporter: DesZodiak | Owner: nobody Status: new | Milestone: Component: django.contrib.admin | Version: 1.1 Keywords: django admin multiple queries | Stage: Unreviewed Has_patch: 0 | -------------------------------------------+-------------------------------- When i am trying to edit user in django admin, admin app makes a lot of queries (see below). The difference between them just in id of element. This queries makes while ModelAdmin form renders. Everything below i took from django-debug-toolbar.
Here is duplicate query: {{{ SELECT "auth_permission"."id", "auth_permission"."name", "auth_permission"."content_type_id", "auth_permission"."codename" FROM "auth_permission" INNER JOIN "django_content_type" ON ("auth_permission"."content_type_id" = "django_content_type"."id") ORDER BY "django_content_type"."app_label" ASC, "auth_permission"."codename" ASC }}} Here is execution stack ||Line||Method||File|| ||226||wrapper||/home/alex/Develop/Django/test/env/lib/python2.6/site- packages/django/contrib/admin/options.py|| ||186||inner||/home/alex/Develop/Django/test/env/lib/python2.6/site- packages/django/contrib/admin/sites.py|| ||873||change_view||/home/alex/Develop/Django/test/env/lib/python2.6/site- packages/django/contrib/admin/options.py|| ||590||render_change_form||/home/alex/Develop/Django/test/env/lib/python2.6 /site-packages/django/contrib/admin/options.py|| ||231||render||/home/alex/Develop/Django/test/env/lib/python2.6/site- packages/django/contrib/admin/widgets.py|| ||36||render||/home/alex/Develop/Django/test/env/lib/python2.6/site- packages/django/contrib/admin/widgets.py|| And part from template ||9||{% if field.is_checkbox %}|| ||10||{{ field.field }}{{ field.label_tag }}|| ||11||{% else %}|| ||12||{{ field.label_tag }}{{ field.field }}|| ||13||{% endif %}|| ||14||{% if field.field.field.help_text %}<p class="help">{{ field.field.field.help_text|safe }}</p>{% endif %}|| ||15||</div>|| -- Ticket URL: <http://code.djangoproject.com/ticket/13118> Django <http://code.djangoproject.com/> The Web framework for perfectionists with deadlines. -- You received this message because you are subscribed to the Google Groups "Django updates" group. To post to this group, send email to django-upda...@googlegroups.com. To unsubscribe from this group, send email to django-updates+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-updates?hl=en.