From 682b9dc3bb3a7d159570154f35476261f49c2e24 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Wed, 30 Dec 2009 08:12:20 +0000 Subject: - Patch #659570 by brianV: added missing index to taxonomy_get_term_by_name() query. --- modules/taxonomy/taxonomy.install | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'modules') diff --git a/modules/taxonomy/taxonomy.install b/modules/taxonomy/taxonomy.install index 57ae17e4b..c2d58c759 100644 --- a/modules/taxonomy/taxonomy.install +++ b/modules/taxonomy/taxonomy.install @@ -72,6 +72,7 @@ function taxonomy_schema() { 'indexes' => array( 'taxonomy_tree' => array('vid', 'weight', 'name'), 'vid_name' => array('vid', 'name'), + 'name' => array('name'), ), ); @@ -429,3 +430,10 @@ function taxonomy_update_7006() { )); } +/** + * Add index on taxonomy_term_data.name column to speed up taxonomy_get_term_by_name(). + */ +function taxonomy_update_7007() { + db_add_index('taxonomy_term_data', 'name', array('name')); +} + -- cgit v1.2.3