Hallo Peter Thomassen,
"Replace a join with a subquery. For example, use this query:
...
Ebenfalls http://dev.mysql.com/doc/mysql/en/Optimising_subqueries.html.
These tricks might cause programs to go faster or slower. Using MySQL facilities like the BENCHMARK() function, you can get an idea about what helps in your own situation.
Gleiche Quelle :-)
Freundliche Grüsse,
Vinzenz