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

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)