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.cvs.patch614 bytesfgm

Comments

fgm’s picture

Title: Query optimization in taxonomy_node_form » Query optimization in 4.6x taxonomy_node_form
Version: x.y.z » 4.6.3
Status: Needs review » Closed (won't fix)

Dries ported it to HEAD for 4.7 and says it won't be included in the 4.6.x branch

See http://drupal.org/node/29151 for details.