add index on popularity count

diff --git a/src/catalogue/migrations/0022_auto_20180226_1503.py b/src/catalogue/migrations/0022_auto_20180226_1503.py
new file mode 100644 (file)
index 0000000..a673f42
--- /dev/null
+++ b/src/catalogue/migrations/0022_auto_20180226_1503.py
@@ -0,0 +1,19 @@
+# -*- coding: utf-8 -*-
+from __future__ import unicode_literals
+
+from django.db import migrations, models
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('catalogue', '0021_auto_20171222_1404'),
+    ]
+
+    operations = [
+        migrations.AlterField(
+            model_name='bookpopularity',
+            name='count',
+            field=models.IntegerField(default=0, db_index=True),
+        ),
+    ]

diff --git a/src/catalogue/models/book.py b/src/catalogue/models/book.py
index 0f664c4..8b85ec7 100644 (file)
--- a/src/catalogue/models/book.py
+++ b/src/catalogue/models/book.py
@@ -715,4 +715,4 @@ add_file_fields()
 
 class BookPopularity(models.Model):
     book = models.OneToOneField(Book, related_name='popularity')
-    count = models.IntegerField(default=0)
+    count = models.IntegerField(default=0, db_index=True)