Files
bugsink/teams/migrations/0002_team_teams_team_name_43e047_idx.py
Klaas van Schelven 86e8c4318b Add indexes on fields on which we order and vice versa
Triggered by issue_event_list being more than 5s on "emu" (my 1,500,000 event
test-machine). Reason: sorting those events on non-indexed field. Switching
to a field-with-index solved it.

I then analysed (grepped) for "ordering" and "order_by" and set indexes
accordingly and more or less indiscriminately (i.e. even on tables that are
assumed to have relatively few rows, such as Project & Team).
2025-02-04 21:19:24 +01:00

18 lines
387 B
Python

# Generated by Django 4.2.18 on 2025-02-04 20:17
from django.db import migrations, models
class Migration(migrations.Migration):
dependencies = [
("teams", "0001_b_squashed_initial"),
]
operations = [
migrations.AddIndex(
model_name="team",
index=models.Index(fields=["name"], name="teams_team_name_43e047_idx"),
),
]