Add useful indexes for performance as part of Distil migrations
Registered by
Adrian Turjak
Distil should create it's own indexes for certain tables (notably usage_entry) to optimise against the very specific queries that we do against the database when using the service APIs.
In Alembic that is done via:
http://
One useful index in particular is:
op.create_
As part of this blueprint we should ideally also investigate our other queries and see if any other indexes might also be useful.
Blueprint information
- Status:
- Not started
- Approver:
- None
- Priority:
- Undefined
- Drafter:
- Adrian Turjak
- Direction:
- Needs approval
- Assignee:
- None
- Definition:
- New
- Series goal:
- None
- Implementation:
- Unknown
- Milestone target:
- None
- Started by
- Completed by
Related branches
Related bugs
Sprints
Whiteboard
(?)