If you have a view and add a selective taxonomy filter the view will run one query for every taxonomy term in the result set. While this is probably very little performance hit when there are only a few dozen taxonomy terms in the result set, if the vocabulary has a lot of terms it can quickly grow out of control.

Comments

jojonaloha’s picture

Status: Active » Needs review
StatusFileSize
new1.69 KB

Attached is a patch that executes one query to get all the term names keyed by tid.

infojunkie’s picture

Status: Needs review » Closed (won't fix)

This module has been deprecated in favour of https://drupal.org/project/views_selective_filters. Please test there and reopen if necessary.