List:Cluster« Previous MessageNext Message »
From:Steve Kurzeja Date:October 10 2008 8:19pm
Subject:Re: slow selects
View as plain text  
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

Thread
slow selectsNick Keefen6 Oct
  • RE: slow selectsJeff Sturm6 Oct
    • Re: slow selectsNick Keefen6 Oct
      • Re: slow selectsStewart Smith8 Oct
        • Re: slow selectsMark Callaghan10 Oct
          • Re: slow selectsMikael Ronstrom11 Oct
      • Re: slow selectsSteve Kurzeja10 Oct