Re: Query Performance

[Felix Geerinckx]

Sergej Shablakov wrote:

> I'll try to apply some of your thought but before:
>
> (And may be this is a question to the development team.)
>
> Has anyone ever tried to have more than 10-12 JOINs in one query and how was the performance
> when adding additional ones???

Regularly up to 15 tables, but mostly eq_refs (with one resulting row) -- this is also what you should have.

> In my case each JOIN slows the request 10 times!

Again, what is the output of

EXPLAIN SELECT .... \G

for your query? Can you post this output?

--
felix
Please use BBCode to format your messages in this forum.