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

fgm drupal-devel at drupal.org
Thu Aug 18 21:07:22 UTC 2005


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

 Project:      Drupal
 Version:      4.6.3
 Component:    taxonomy.module
 Category:     feature requests
 Priority:     minor
 Assigned to:  fgm
 Reported by:  fgm
 Updated by:   fgm
 Status:       patch (code needs review)
 Attachment:   http://drupal.org/files/issues/taxonomy.module.463.patch (630 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




More information about the drupal-devel mailing list