From 4c8c6eefb87a2c385a9b9a4960ec59f98c91228b Mon Sep 17 00:00:00 2001 From: webchick Date: Wed, 1 Feb 2012 09:12:19 -0800 Subject: Issue #336483 by brianV, catch: Fixed Performance: SELECT MAX(comment_count()) FROM node_comment_statistics() does full table scan. --- modules/comment/comment.install | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) (limited to 'modules') diff --git a/modules/comment/comment.install b/modules/comment/comment.install index d4bf76f93..7312e2a31 100644 --- a/modules/comment/comment.install +++ b/modules/comment/comment.install @@ -226,8 +226,11 @@ function comment_update_7004() { )); db_add_index('node_comment_statistics', 'cid', array('cid')); - // Add an index on the comment_count. - db_add_index('node_comment_statistics', 'comment_count', array('comment_count')); + // The comment_count index may have been added in Drupal 6. + if (!db_index_exists('node_comment_statistics', 'comment_count')) { + // Add an index on the comment_count. + db_add_index('node_comment_statistics', 'comment_count', array('comment_count')); + } } /** -- cgit v1.2.3