Le mercredi 26 août 2009 à 02:25 +0200, Gerhard Killesreiter a écrit : > Your "tips" are mostly garbage. They may help certain queries under > certain RDBMSses, but are not generally applicable.
I am removing specific MySQL and PostgreSQL information: http://drupal.org/node/559302 First page gives information about misleading Drupal stats: http://drupal.org/node/559320 Second page is a short introduction to EXPLAIN ANALYSE: http://drupal.org/node/559720 Third page is an introduction to using LEFT JOINs in place of INNER JOINs: http://drupal.org/node/559474 (I don't believe that INNER JOINs are faster than LEFT JOINs because an INNER JOIN removes NULL values and thus processes using sequential scans internaly) Indexes on dual fields may result in slow queries http://drupal.org/node/555558 Avoid Distinct on JOINS whenever possible Avoid using DISTINCT in JOINs whenever possible and write straight JOINs Kind regards, Jean-Michel
signature.asc
Description: Ceci est une partie de message numériquement signée
