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 /modules/system/system.install | |
| 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.
Diffstat (limited to 'modules/system/system.install')
| -rw-r--r-- | modules/system/system.install | 9 |
1 files changed, 9 insertions, 0 deletions
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. */ |