[drupal-devel] [task] Query optimization in taxonomy_node_form

fgm drupal-devel at drupal.org
Thu Aug 18 21:06:08 UTC 2005

Issue status update for 
Post a follow up: 

 Project:      Drupal
 Version:      cvs
 Component:    taxonomy.module
 Category:     tasks
 Priority:     minor
 Assigned to:  fgm
 Reported by:  fgm
 Updated by:   fgm
 Status:       patch (code needs review)
 Attachment:   http://drupal.org/files/issues/taxonomy.module.cvs.patch (614 bytes)

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.


More information about the drupal-devel mailing list