[TYPO3-dev] Use of subqueries

Martin Kutschker masi-no at spam-typo3.org
Mon Oct 12 15:53:02 CEST 2009


Bernhard Kraft schrieb:
> 
> It depends on what you want to achieve. In many cases it is also
> possible to avoid subqueries by clever use of "JOIN" or "LEFT JOIN".

And be sure to check the output of EXPLAIN for both queries. Depending on your query, your indices
and the number of rows in the tables one version may be faster. I don't think that sub-queries are
slower in all circumstances.

Masi




More information about the TYPO3-dev mailing list