From 579e39b46555854b0b38b518f59a71cd9e71c4ae Mon Sep 17 00:00:00 2001 From: Angie Byron Date: Wed, 17 Feb 2010 05:31:31 +0000 Subject: #314349 by mfb, Damien Tournoud, catch, scor, cha0s: Fixed random failures from comment paging tests. --- modules/comment/comment.install | 10 +++++++++- 1 file changed, 9 insertions(+), 1 deletion(-) (limited to 'modules/comment/comment.install') diff --git a/modules/comment/comment.install b/modules/comment/comment.install index 9eff90068..0ef098a78 100644 --- a/modules/comment/comment.install +++ b/modules/comment/comment.install @@ -351,6 +351,14 @@ function comment_update_7013(&$sandbox) { } } +/** + * Optimize index for comment_num_new() and comment_new_page_count(). + */ +function comment_update_7014() { + db_drop_index('comment', 'comment_num_new'); + db_add_index('comment', 'comment_num_new', array('nid', 'status', 'created', 'cid', 'thread')); +} + /** * @} End of "defgroup updates-6.x-to-7.x" * The next series of updates should start at 8000. @@ -454,7 +462,7 @@ function comment_schema() { ), 'indexes' => array( 'comment_status_pid' => array('pid', 'status'), - 'comment_num_new' => array('nid', 'changed', 'status'), + 'comment_num_new' => array('nid', 'status', 'created', 'cid', 'thread'), 'comment_uid' => array('uid'), 'comment_nid_language' => array('nid', 'language'), ), -- cgit v1.2.3