[development] drupal on postgresql benchmark

Gerhard Killesreiter gerhard at killesreiter.de
Mon Nov 26 18:42:42 UTC 2007


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Bill Moran schrieb:
> (MySQL, for example is
> faster at executing simply SELECT queries than anything else
> out there, whereas PostgreSQL is faster at complex joins ...
> if Drupal fetches related data from 5 tables in five separate
> SELECTS instead of 1 big SELECT with a bunch of joins, then it
> will always be faster on MySQL).

Drupal usually goes for joins rather than multiple single selects.

Cheers,
	Gerhard
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHSxOifg6TFvELooQRAnw8AKCAnN5yBGC5lzZaiMvAlU4+Jp0SjgCaAnPu
zRqdT1Vt/Z+9nzF9vehyxrk=
=Ot4G
-----END PGP SIGNATURE-----


More information about the development mailing list