List:General Discussion« Previous MessageNext Message »
From:Sebastian Mendel Date:April 14 2008 6:25am
Subject:Re: Two MySql servers, but very different performances for a SELECT
JOIN
View as plain text  
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
Thread
Two MySql servers, but very different performances for a SELECT JOINtmarly11 Apr
  • Re: Two MySql servers, but very different performances for a SELECT JOINRob Wultsch11 Apr
  • Re: Two MySql servers, but very different performances for a SELECTJOINTristan Marly13 Apr
    • Re: Two MySql servers, but very different performances for a SELECTJOINSebastian Mendel14 Apr
Re: Two MySql servers, but very different performances for a SELECT JOINtmarly15 Apr
  • Re: Two MySql servers,but very different performances for a SELECT JOINWm Mussatto15 Apr
    • Re: Two MySql servers, but very different performances for a SELECT JOINRob Wultsch15 Apr
  • Re: Two MySql servers, but very different performances for a SELECT JOINtmarly16 Apr
    • Re: Two MySql servers, but very different performances for a SELECT JOINRob Wultsch16 Apr
      • Re: Two MySql servers, but very different performances for a SELECT JOINtmarly16 Apr