[development] Guidelines for writing efficient SQL code
jm at poure.com
Tue Aug 25 23:07:47 UTC 2009
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!
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Size: 197 bytes
Desc: Ceci est une partie de message num?riquement sign?e
More information about the development