On 21 Jul 2006, at 15:15, Moshe Weitzman wrote:
i can't think of any reasonable assumptions. to me, the waste is not that we have to perform so many queries, but rather that we do so on every page view even though the data rarely changes. to address that, one should use mysql query cache or even memcached.
A query cache only eliminates part of the overhead. Most of the overhead comes from Drupal's database abstraction layer, not from execution the actual SQL query: http://buytaert.net/drupal-database-interaction We gain most if we eliminate calls to db_query(). We use a MySQL query cache on drupal.org, and the one query that retrieves the URL alias is still to most expensive query (accumulated cost).
fyi, devel.module just got the ability to do query logging to the DB. killes and i just need to quash one silly bug and it will be ready.
Does it (still) accumulate data across different page views? -- Dries Buytaert :: http://www.buytaert.net/