[development] Guidelines for writing efficient SQL code

[Gerhard Killesreiter]

-----BEGIN PGP SIGNED MESSAGE-----
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.

Cheers,
	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.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkqUgOkACgkQfg6TFvELooRolACfbCk/RHEKDIEM8kGWOi4lEE3l
0vgAoLjKQ61D57Lc6l8mAnOvC53COsmj
=vq0l
-----END PGP SIGNATURE-----