In response to Gerhard Killesreiter <gerhard@killesreiter.de>:
-----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.
*shrug* My point is: a) Let me send you a tweaked postgresql.conf file and well find out whether the performance difference is simply a matter of untuned configuration and ... b) Let me have the query log after the test and I'll see if I can identify any queries that could be improved, then someone else can test to see if the improved queries are acceptable from the MySQL standpoint. -- Bill Moran http://www.potentialtech.com