diff options
| author | Michael Foster <savetheinternet@tinyboard.org> | 2013-09-01 22:15:03 +1000 |
|---|---|---|
| committer | Michael Foster <savetheinternet@tinyboard.org> | 2013-09-01 22:15:03 +1000 |
| commit | 22fcca343f8d4e820745a673972286b47a6a17ba (patch) | |
| tree | da8a844579b089ced636122c6ad0f7589f442ac1 | |
| parent | cf3173d226271c59eab1fe841baec6ec309771f3 (diff) | |
New index in post tables for listing threads slightly faster (index pages)
| -rw-r--r-- | install.php | 7 | ||||
| -rw-r--r-- | templates/posts.sql | 3 |
2 files changed, 8 insertions, 2 deletions
diff --git a/install.php b/install.php index 967af7de..d60e5aab 100644 --- a/install.php +++ b/install.php @@ -1,7 +1,7 @@ <?php // Installation/upgrade file -define('VERSION', 'v0.9.6-dev-15'); +define('VERSION', 'v0.9.6-dev-16'); require 'inc/functions.php'; @@ -381,6 +381,11 @@ if (file_exists($config['has_installed'])) { query("ALTER TABLE ``bans`` ADD INDEX `ip` (`ip`)") or error(db_error()); query("ALTER TABLE ``noticeboard`` ADD INDEX `time` (`time`)") or error(db_error()); query("ALTER TABLE ``pms`` ADD INDEX `to` (`to`, `unread`)") or error(db_error()); + case 'v0.9.6-dev-15': + foreach ($boards as &$board) { + query(sprintf("ALTER TABLE ``posts_%s`` + ADD INDEX `list_threads` (`thread`, `sticky`, `bump`)", $board['uri'])) or error(db_error()); + } case false: // Update version number file_write($config['has_installed'], VERSION); diff --git a/templates/posts.sql b/templates/posts.sql index b35865ca..c1f491f2 100644 --- a/templates/posts.sql +++ b/templates/posts.sql @@ -29,6 +29,7 @@ CREATE TABLE IF NOT EXISTS ``posts_{{ board }}`` ( KEY `thread_id` (`thread`,`id`), KEY `filehash` (`filehash`(40)), KEY `time` (`time`), - KEY `ip` (`ip`) + KEY `ip` (`ip`), + KEY `list_threads` (`thread`, `sticky`, `bump`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
\ No newline at end of file |