]> git.mxchange.org Git - ctracker.git/commitdiff
Index on count column to improve SUM queries
authorRoland Häder <roland@mxchange.org>
Tue, 26 Jul 2016 08:11:57 +0000 (10:11 +0200)
committerRoland Häder <roland@mxchange.org>
Tue, 26 Jul 2016 08:11:57 +0000 (10:11 +0200)
Signed-off-by: Roland Häder <roland@mxchange.org>
libs/lib_updates.php

index 41762b8414c26aebc8a36eb539bd6171f45d2f60..197e984868b03634d5c674833185a72512798044 100644 (file)
@@ -77,6 +77,11 @@ FOREIGN KEY ( `ctracker_data_id` ) REFERENCES `' . $GLOBALS['ctracker_dbname'] .
                5 => array(
                        "ALTER TABLE `ctracker_data` ADD `request_method` VARCHAR( 255 ) NULL DEFAULT NULL COMMENT 'HTTP request method' AFTER `referer`, ADD INDEX ( `request_method` )",
                ),
+
+               // Index on count
+               6 => array(
+                       'ALTER TABLE `ctracker_data` ADD INDEX `count` (`count`)',
+               ),
        );
 }