Re: performances and optimization in multiple join queries

2008-01-17 Thread Sebastian Mendel
[EMAIL PROTECTED] schrieb: Hello everybody! I have a huge query (something similar to a search engine), full of left joins and my testing server takes several minutes each time to output the recordset. I was looking for some (right) way to optimize the search. there were some solutions propose

Re: performances and optimization in multiple join queries

2008-01-17 Thread Moon's Father
So many tables join.OH. Can you paste your explain results here? On 1/17/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hello everybody! > > I have a huge query (something similar to a search engine), full of left > joins and my testing server takes several minutes each time to output the >

performances and optimization in multiple join queries

2008-01-17 Thread sguglia
Hello everybody! I have a huge query (something similar to a search engine), full of left joins and my testing server takes several minutes each time to output the recordset. I was looking for some (right) way to optimize the search. there were some solutions proposed around, like split in n sim