From: Steve Kurzeja
Date: October 10 2008 8:19pm
Subject: Re: slow selects
List-Archive: http://lists.mysql.com/cluster/6265
Message-Id: <5f7152000810101319o4723f115jcd81c30c646f4846@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_16824_25402840.1223669972629"

------=_Part_16824_25402840.1223669972629
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi Nick,

On Tue, Oct 7, 2008 at 10:51 AM, Nick Keefen <nk.nightkid@stripped> wrote:

> hi Jeff.
>
> I'm impressed. I figured that was the optimizer's fault and tried to change
> its depth but it did not help. STRAIGHT_JOIN gives the perfect performance
> of split seconds!
>
> Unfortunately it might be tricky for me to modify my webapp (i'm more of a
> system administrator and am uncomfortable with the idea of modifying the
> client's code). Is there any way to make the query optimizer work correctly?
>


A possible use of MySQL proxy if you really got desperate.

Steve

------=_Part_16824_25402840.1223669972629--