On Thu, 26 May 2005, [UTF-8] Ãlvaro Ortiz wrote:
My chrystal ball says that some queries in Drupal 4.6 indeed were less than optimal. In particular those for the access controll system. Teh chrystal ball recommends to update to Drupal 4.6.
Since you had your chrystall ball I did not have to say... :)
The first slow queries were like:
SELECT DISTINCT(n.nid), n.sticky, n.created FROM node n INNER JOIN node_access na ON (na.nid = 0 OR na.nid = n.nid)
^^^^^^ ^ ^^^^^^^^^^^^^^^
We found out that this construct does make for slow queries. It usually does not bring down a server, though. It is however possible, that mysql needs a lot of memory to accomodate for this kind of queries as a lot of table rows need to be looked at.
The upgrade was in my to-do list for some time now, so the time has come.
Yep.
Cheers, Gerhard