From: Dan Nelson
Date: August 25 2003 7:52pm
Subject: Re: Optimize Question
List-Archive: http://lists.mysql.com/mysql/148463
Message-Id: <20030825195237.GD26367@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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