Re: Left Join slow on Windows

[Petr Vileta]

> I am experiencing problems with a query which is slow (16sec) on Windows
> but not on Linux (2sec).
>
> Can anyone suggest why the query would be so slow on Windows, and
> perhaps recommend a solution? I am having problems with PHP timing out
> before it can display the results of this particular query.
Because Bill Gates :-)
Have you the same MySQL configuration on both PCs?
Compare  SHOW VARIABLES on both ant take look to every what begin "max_" ;-)

Petr Vileta, Czech republic