[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
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
>
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