This is step one for getting forums optimized.

Comments

david strauss’s picture

david strauss
he/him
commented

That was easy:

ALTER TABLE {term_data} DROP INDEX vid;
ALTER TABLE {term_data} ADD INDEX taxonomy_tree (vid, weight, name);

Now taxonomy_get_tree can run without a filesort.

moshe weitzman’s picture

moshe weitzman commented

if this is still valid, lets make a patch and get it in.

wim leers’s picture

wim leers
Location Ghent 🇧🇪🇪🇺
commented

Bump!

Let's get this in D6!

RobRoy’s picture

RobRoy commented

Have you seen my issue at http://drupal.org/node/106015 which would cache the tree? It seems complimentary and offers a huge performance boost, please review if you can!

catch’s picture

catch
he/him
Primary language English
commented
Status: Active » Closed (duplicate)

Marking as duplicate of: http://drupal.org/node/164532