I'm not super sure how to react to this, especially after seeing this thread: http://drupal.org/node/559424 Jean-Michel, I think you misunderstand joins as they pertain to best practice and performance. Are we all basically in agreement that INNER JOIN is the faster of the two for most purposes? -D Jean-Michel Pouré wrote:
Dear Friends,
I welcome your comments on this short guide for writing efficient SQL code in Drupal: http://drupal.org/node/559302
Feel free to start hunting for speed on the two issues mentioned (logging and LEFT JOINs). I will add several tips in the next days.
The forum code proved to be heavily broken and I could debug it in 4 hours. So it is very likely that the entire Drupal 6.dev is at stake. Probably Drupal 7 alpha too.
Because Drupal makes little use of LEFT JOINs in the code, it is likely that it cannot scale well. Hence a reputation to be slow. But it can change rapidly if you fix the code and apply the tips.
I will be back tomorrow with more tips. Hunt for speed now!
Kind regards, Jean-Michel