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

[fgm]

Issue status update for 
http://drupal.org/node/29150
Post a follow up: 
http://drupal.org/project/comments/add/29150

 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.




fgm