[drupal-support] Large taxonomy hangs server?

[Gerhard Killesreiter]

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