On Fri, Nov 18, 2011 at 10:55 AM, Dre <dreb...@gmail.com> wrote: > It takes 8096 msec for a model with 1000 database rows to be opened > using the admin interface with debug-toolbar enabled. It is paginated > to > 100 entries per page, and SQL makes 339 queries in 128.77 msec. > I have two foreign keys on this model to models with < 20 entries > each.
this is a typical query explosion. it happens when you do a simple queryset, but when processing each item, it has to fetch some related object, so it's one or two extra queries.... per item. for example, do you use related objects in your __unicode__() method? -- Javier -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
