On Mar 22, 9:56 pm, Javier Guerra Giraldez <jav...@guerrag.com> wrote: > On Tue, Mar 22, 2011 at 9:49 PM, Brian Neal <bgn...@gmail.com> wrote: > > I studied the SQL that Django generated and it seemed fine to me. > > That's why I wonder if it is a MySQL issue since the EXPLAIN said it > > had a possible key (PRIMARY) but then ended up not using it (bottom > > one): > > that's because it saw so few rows (just 15) that it was cheaper to > scan the whole thing instead of using the index >
I see. There are in fact only 15 forums. But why does it take 40 seconds? I can get much better results if I do a select on each forum individually and combine them together in Python code. So in this case 15 selects is far better than 1. Maybe that's an expected result in some cases, but it sure surprised me. Thank you for that, that helps a bit. Best, BN -- 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.
