On Friday, February 14, 2014 4:58:21 PM UTC-4:30, sha wrote:
>
> What I would like to know is: 
> 1. Is there a reason why mysql performance is so slow on left outer join? 
> (even with indexes)
>
>>
>>
That is not a MySQL issue with outher joins, nor any other RDBMS issue with 
outher join. That depends so much in the way you wrote your query and the 
conditions for joining you are putting in; you can be doing a full table 
scan or cartesian product of two (or more) relations. The index are used 
whenever possible or whenever the RDBMS is able to use them.

Carsten's manual optimization seems better than that of the ORM for this 
case.

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/122ba3f2-3d9f-4059-8da1-0ce7364bd28c%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to