diff options
| author | Dries Buytaert <dries@buytaert.net> | 2009-07-30 19:27:11 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2009-07-30 19:27:11 +0000 |
| commit | d455a8d9213962114d25bbade369cc7fe60239f6 (patch) | |
| tree | 59eb165a592a7edf068d69a59c3e64a197335325 | |
| parent | 926606eeca106fb2e0eff20f3b1bff205924fd36 (diff) | |
| download | brdo-d455a8d9213962114d25bbade369cc7fe60239f6.tar.gz brdo-d455a8d9213962114d25bbade369cc7fe60239f6.tar.bz2 | |
- Patch #336483 by brianV: SELECT MAX(comment_count) FROM node_comment_statistics did a full table scan so added an index.
| -rw-r--r-- | modules/comment/comment.install | 1 | ||||
| -rw-r--r-- | modules/system/system.install | 9 |
2 files changed, 10 insertions, 0 deletions
diff --git a/modules/comment/comment.install b/modules/comment/comment.install index 45afd76bd..780753c75 100644 --- a/modules/comment/comment.install +++ b/modules/comment/comment.install @@ -287,6 +287,7 @@ function comment_schema() { 'primary key' => array('nid'), 'indexes' => array( 'node_comment_timestamp' => array('last_comment_timestamp'), + 'comment_count' => array('comment_count'), ), 'foreign keys' => array( 'nid' => array('node' => 'nid'), diff --git a/modules/system/system.install b/modules/system/system.install index 20f35d549..a21d9f503 100644 --- a/modules/system/system.install +++ b/modules/system/system.install @@ -2257,6 +2257,15 @@ function system_update_7029() { } /** + * Add an index to node_comment_statistics on comment_count. + */ +function system_update_7030() { + $ret = array(); + db_add_index($ret, 'node_comment_statistics', 'comment_count', array('comment_count')); + return $ret; +} + +/** * @} End of "defgroup updates-6.x-to-7.x" * The next series of updates should start at 8000. */ |