Adam Douglas writes:
<cut>
>
> Alright, but is there no way then to decrease my query time of 14 seconds
> (includes 3 queries) to something more reasonable for use on-line? 10
> seconds according to stats is the maximum limit.
>
> Maybe I'm not understanding things correctly here, but I do not have a
> Cartesian product since my query will only return 1 result. Cartesian is
> when MySQL has to match row for row when tables do not have any relations
> correct (in brief)?
>
> Well that doesn't make sense to me, so how long should such a task take
> then? I've ran it all night and still it wasn't finished, seems to be hung
> not just taking to long. When you have a table with 42,000+ rows it should
> take more then 8 hours to update no?
>
If it returns one row only, then I was wrong, it is not Cartesion
product.
But your query is neither 1 -> N -> N .... join, that is resolved
faster.
As I told you before you do miss some indices.
You can also speed up things by using /* STRAIGHT_JOIN */ where possible.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <sinisa@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
