Performance: add indexes for cached labels

3 files changed, 73 insertions, 5 deletions

diff --git a/archaeological_finds/migrations/0011_auto_20171012_1316.py b/archaeological_finds/migrations/0011_auto_20171012_1316.py
new file mode 100644
index 000000000..6fabd578f
--- /dev/null
+++ b/archaeological_finds/migrations/0011_auto_20171012_1316.py
@@ -0,0 +1,65 @@
+# -*- 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_finds', '0010_auto_20171011_1644'),
+    ]
+
+    operations = [
+        migrations.AlterField(
+            model_name='basefind',
+            name='cache_complete_id',
+            field=models.TextField(blank=True, db_index=True, help_text='Cached value - do not edit', null=True, verbose_name='Complete ID'),
+        ),
+        migrations.AlterField(
+            model_name='basefind',
+            name='cache_short_id',
+            field=models.TextField(blank=True, db_index=True, help_text='Cached value - do not edit', null=True, verbose_name='Short ID'),
+        ),
+        migrations.AlterField(
+            model_name='find',
+            name='cached_label',
+            field=models.TextField(blank=True, db_index=True, null=True, verbose_name='Cached name'),
+        ),
+        migrations.AlterField(
+            model_name='historicalbasefind',
+            name='cache_complete_id',
+            field=models.TextField(blank=True, db_index=True, help_text='Cached value - do not edit', null=True, verbose_name='Complete ID'),
+        ),
+        migrations.AlterField(
+            model_name='historicalbasefind',
+            name='cache_short_id',
+            field=models.TextField(blank=True, db_index=True, help_text='Cached value - do not edit', null=True, verbose_name='Short ID'),
+        ),
+        migrations.AlterField(
+            model_name='historicalfind',
+            name='cached_label',
+            field=models.TextField(blank=True, db_index=True, null=True, verbose_name='Cached name'),
+        ),
+        migrations.AlterField(
+            model_name='historicaltreatment',
+            name='cached_label',
+            field=models.TextField(blank=True, db_index=True, null=True, verbose_name='Cached name'),
+        ),
+        migrations.AlterField(
+            model_name='historicaltreatmentfile',
+            name='cached_label',
+            field=models.TextField(blank=True, db_index=True, null=True, verbose_name='Cached name'),
+        ),
+        migrations.AlterField(
+            model_name='treatment',
+            name='cached_label',
+            field=models.TextField(blank=True, db_index=True, null=True, verbose_name='Cached name'),
+        ),
+        migrations.AlterField(
+            model_name='treatmentfile',
+            name='cached_label',
+            field=models.TextField(blank=True, db_index=True, null=True, verbose_name='Cached name'),
+        ),
+    ]
diff --git a/archaeological_finds/models_finds.py b/archaeological_finds/models_finds.py
index e58d14f7e..966dd1065 100644
--- a/archaeological_finds/models_finds.py
+++ b/archaeological_finds/models_finds.py
@@ -231,10 +231,10 @@ class BaseFind(BulkUpdatedItem, BaseHistorizedItem, OwnPerms):
     line = models.LineStringField(_(u"Line"), blank=True, null=True)
     polygon = models.PolygonField(_(u"Polygon"), blank=True, null=True)
     cache_short_id = models.TextField(
-        _(u"Short ID"), blank=True, null=True,
+        _(u"Short ID"), blank=True, null=True, db_index=True,
         help_text=_(u"Cached value - do not edit"))
     cache_complete_id = models.TextField(
-        _(u"Complete ID"), blank=True, null=True,
+        _(u"Complete ID"), blank=True, null=True, db_index=True,
         help_text=_(u"Cached value - do not edit"))
     history = HistoricalRecords()
     RELATED_POST_PROCESS = ['find']
@@ -748,7 +748,8 @@ class Find(BulkUpdatedItem, ValueGetter, BaseHistorizedItem, ImageModel,
     appraisal_date = models.DateField(_(u"Appraisal date"), blank=True,
                                       null=True)
 
-    cached_label = models.TextField(_(u"Cached name"), null=True, blank=True)
+    cached_label = models.TextField(_(u"Cached name"), null=True, blank=True,
+                                    db_index=True)
     history = HistoricalRecords()
     BASKET_MODEL = FindBasket
 
diff --git a/archaeological_finds/models_treatments.py b/archaeological_finds/models_treatments.py
index 0ffcd87fa..b4d98528b 100644
--- a/archaeological_finds/models_treatments.py
+++ b/archaeological_finds/models_treatments.py
@@ -115,7 +115,8 @@ class Treatment(DashboardFormItem, ValueGetter, BaseHistorizedItem,
                                        blank=True, null=True)
     target_is_basket = models.BooleanField(_(u"Target a basket"),
                                            default=False)
-    cached_label = models.TextField(_(u"Cached name"), null=True, blank=True)
+    cached_label = models.TextField(_(u"Cached name"), null=True, blank=True,
+                                    db_index=True)
     history = HistoricalRecords()
 
     class Meta:
@@ -506,7 +507,8 @@ class TreatmentFile(DashboardFormItem, ClosedItem, BaseHistorizedItem,
     reception_date = models.DateField(_(u'Reception date'), blank=True,
                                       null=True)
     comment = models.TextField(_(u"Comment"), null=True, blank=True)
-    cached_label = models.TextField(_(u"Cached name"), null=True, blank=True)
+    cached_label = models.TextField(_(u"Cached name"), null=True, blank=True,
+                                    db_index=True)
     history = HistoricalRecords()
 
     class Meta: