[development] Guidelines for writing efficient SQL code

Gerhard Killesreiter gerhard at killesreiter.de
Wed Aug 26 00:25:13 UTC 2009

Hash: SHA1

Jean-Michel Pouré schrieb:
> 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!

Your "tips" are mostly garbage. They may help certain queries under
certain RDBMSses, but are not generally applicable.

	Gerhard, who actually spent some time to _remove_ LEFT JOINS in Drupal
4.x because they were slower...

P.S.: If you ever mention something like "we should leave mysql and go
pgsql only because mysql is not a serious database" again, I'll block
your account on d.o. There's enough stupid in the world, we don't need
to give it a place on d.o.

Version: GnuPG v1.4.9 (GNU/Linux)


More information about the development mailing list