[development] Guidelines for writing efficient SQL code

[Domenic Santangelo]

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