On 8/9/11 9:27 PM, Wade Preston Shearer wrote: > Sorry… the =39 shouldn't have been in there. It should return > multiple rows. I pasted the wrong query. I was testing with that. > Here is the query: > > http://pastie.org/2348436
What times do you get for each of the inner queries, and how many results? To optimize this query, you first need to identify which part is slow, and this query has multiple parts. Also, what version of MySQL are you using? Steve _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
