Re: Optimize Question

[Dan Nelson]

In the last episode (Aug 25), Patrick Crowley said:
> I'm running 3.23.52 locally, but I just noticed my production server
> is running 4.0.12.
> 
> Given the complexity of this query, should I use subqueries instead
> of joins? Would that make any difference?

The subquery equivalent to your joins should be processed exactly the
same way (barring optimizer bugs).  You would have to use 4.1.0 to get
subqueries anyway.

-- 
	Dan Nelson
	dnelson@stripped