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'

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, What ever