I found a solution be changing the MySQL server setting optimizer_search_depth to 3 (default 62)
http://dev.mysql.com/doc/refman/5.0/en/controlling-optimizer.html http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_optimizer_search_depth My query had over 20 INNER JOINTS and it made the optimizer search a long process. So at the moment a value of 3 is fine. On 01.02.2011, at 21:20, Ivo Brodien wrote: > The Change List that I am calling is a Intermediate Table if that is of any > interest. > > Is it possible that there is some sort of circular inner joints or something? > > -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
