Performance: add indexes for cached labels

2 files changed, 27 insertions, 2 deletions

diff --git a/archaeological_warehouse/migrations/0009_auto_20171012_1316.py b/archaeological_warehouse/migrations/0009_auto_20171012_1316.py
new file mode 100644
index 000000000..a25a2d2f2
--- /dev/null
+++ b/archaeological_warehouse/migrations/0009_auto_20171012_1316.py
@@ -0,0 +1,25 @@
+# -*- coding: utf-8 -*-
+# Generated by Django 1.11 on 2017-10-12 13:16
+from __future__ import unicode_literals
+
+from django.db import migrations, models
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('archaeological_warehouse', '0008_auto_20171011_1644'),
+    ]
+
+    operations = [
+        migrations.AlterField(
+            model_name='container',
+            name='cached_label',
+            field=models.CharField(blank=True, db_index=True, max_length=500, null=True, verbose_name='Localisation'),
+        ),
+        migrations.AlterField(
+            model_name='container',
+            name='cached_location',
+            field=models.CharField(blank=True, db_index=True, max_length=500, null=True, verbose_name='Cached location'),
+        ),
+    ]
diff --git a/archaeological_warehouse/models.py b/archaeological_warehouse/models.py
index 41891b341..71f31981a 100644
--- a/archaeological_warehouse/models.py
+++ b/archaeological_warehouse/models.py
@@ -283,9 +283,9 @@ class Container(LightHistorizedItem, ImageModel):
     reference = models.CharField(_(u"Container ref."), max_length=40)
     comment = models.TextField(_(u"Comment"), null=True, blank=True)
     cached_label = models.CharField(_(u"Localisation"), max_length=500,
-                                    null=True, blank=True)
+                                    null=True, blank=True, db_index=True)
     cached_location = models.CharField(_(u"Cached location"), max_length=500,
-                                       null=True, blank=True)
+                                       null=True, blank=True, db_index=True)
     index = models.IntegerField(u"Container ID", default=0)
     external_id = models.TextField(_(u"External ID"), blank=True, null=True)
     auto_external_id = models.BooleanField(