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 /templates/posts.sql | |
| parent | cf3173d226271c59eab1fe841baec6ec309771f3 (diff) | |
New index in post tables for listing threads slightly faster (index pages)
Diffstat (limited to 'templates/posts.sql')
| -rw-r--r-- | templates/posts.sql | 3 |
1 files changed, 2 insertions, 1 deletions
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 |