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

2008-04-13 Thread 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_

Re: Data transfer

2008-04-13 Thread Krishna Chandra Prajapati
Development server has multiple databases. On Fri, Apr 11, 2008 at 3:07 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote: > does your development server have only one database or multiple database. > > regards > anandkl > > > On 4/11/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: > > > > Hi,

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

2008-04-13 Thread Tristan Marly
(cf. in attachment my notes. I attached there to avoid unwanted carriage returns) -- 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' sh