Re: Two MySql servers, but very different performances for a SELECT JOIN

[Sebastian Mendel]

Tristan Marly schrieb:

> First, thanks for all your suggestions and for beeing so reactive.
> 
> @Martin: the explain result was in attachment, but you will have more results in this
> current mail.
> 
> @Rob: you are right, the 'show index' shows strange things, cf. below.
> 
> @Rodolphe: indeed the STRAIGHT_JOIN has been very helpfull, cf. below.
> 
> @Brent: thanks for this very precise and technical answer.


too bad, that all the other list members could not read what was so helpful 
... reply to the author instead of to the list is very useful for the 
audience ... or was it only me who missed their replies (except from Rub 
Wulsch)?

-- 
Sebastian