The current query on which taxonomy_node_form is based is of the form:

SELECT v.*, n.type FROM [...]

But the code does not make use of any of the results except v.vid, using DB server resources uselessly. Patch reduces the query to

SELECT v.vid FROM [...]

This reduces the size of the result set and, to some extent, the work to be performed by the DB server.

CommentFileSizeAuthor
taxonomy.module.463.patch630 bytesfgm
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

chx’s picture

Status: Needs review » Reviewed & tested by the community
Dries’s picture

Version: 4.6.3 » x.y.z
Status: Reviewed & tested by the community » Fixed

Ported your patch to HEAD, and committed it to HEAD. Not going to commit it to DRUPAL-4-6. Thanks fgm.

Anonymous’s picture

Status: Fixed » Closed (fixed)