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