-Original Message-
> > From: django-users@googlegroups.com [mailto:django-users@googlegroups.com]
> > On Behalf Of Ivo Brodien
> > Sent: 01 February 2011 23:49
> > To: django-users@googlegroups.com
> > Subject: Re: Django SQL Query does not stop
>
> &g
t often runs way faster if the query is simplified.
>
> Regards
> Chris
> -Original Message-
> From: django-users@googlegroups.com [mailto:django-users@googlegroups.com] On
> Behalf Of Ivo Brodien
> Sent: 01 February 2011 23:49
> To: django-users@googlegroups.co
runs way faster if the query is simplified.
Regards
Chris
-Original Message-
From: django-users@googlegroups.com [mailto:django-users@googlegroups.com] On
Behalf Of Ivo Brodien
Sent: 01 February 2011 23:49
To: django-users@googlegroups.com
Subject: Re: Django SQL Query does not stop
I
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
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
On 01.02.2011, at 16:55, Tom Evans wrote:
> In the mysql shell:
>
> EXPLAIN SELECT ...
unfortunately same problem. CPU turns to 100% and it is stuck.
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to
On Tue, Feb 1, 2011 at 3:53 PM, Ivo Brodien wrote:
> When I am in admin and I access of a certain model, Django calls mysql with
> an Query which increases mysql CPU load to 99% and it never returns.
>
> If I copy the the SQL Query right into mysql the same thing happens, so it
7 matches
Mail list logo