From 22fcca343f8d4e820745a673972286b47a6a17ba Mon Sep 17 00:00:00 2001 From: Michael Foster Date: Sun, 1 Sep 2013 22:15:03 +1000 Subject: New index in post tables for listing threads slightly faster (index pages) --- templates/posts.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'templates/posts.sql') 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 -- cgit v1.3