Added indexes on frequently used fields

boards/migrations/0051_auto_20161013_1037.py

@@ -0,0 +1,25 b''
+# -*- coding: utf-8 -*-
+# Generated by Django 1.9.5 on 2016-10-13 07:37
+from __future__ import unicode_literals
+
+from django.db import migrations, models
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('boards', '0050_auto_20161008_1745'),
+    ]
+
+    operations = [
+        migrations.AlterField(
+            model_name='post',
+            name='pub_time',
+            field=models.DateTimeField(db_index=True),
+        ),
+        migrations.AlterField(
+            model_name='thread',
+            name='status',
+            field=models.CharField(choices=[('active', 'active'), ('bumplimit', 'bumplimit'), ('archived', 'archived')], db_index=True, default='active', max_length=50),
+        ),
+    ]

boards/models/post/__init__.py

@@ -70,7 +70,7 b' class Post(models.Model, Viewable):'
         ordering = ('id',)
 
     title = models.CharField(max_length=TITLE_MAX_LENGTH, null=True, blank=True)
-    pub_time = models.DateTimeField()
+    pub_time = models.DateTimeField(db_index=True)
     text = TextField(blank=True, null=True)
     _text_rendered = TextField(blank=True, null=True, editable=False)
 

boards/models/thread.py

@@ -98,7 +98,7 b' class Thread(models.Model):'
     last_edit_time = models.DateTimeField()
     max_posts = models.IntegerField(default=get_thread_max_posts)
     status = models.CharField(max_length=50, default=STATUS_ACTIVE,
-            choices=STATUS_CHOICES)
+            choices=STATUS_CHOICES, db_index=True)
     monochrome = models.BooleanField(default=False)
 
     def get_tags(self) -> QuerySet: