Index the token expiry in SQL backend
Registered by
Dolph Mathews
The 'expires' column in the table is not indexed, and only "unexpired" tokens are ever queried from the backend, resulting in very slow performance.
ALTER TABLE token ADD INDEX expires (expires);
Blueprint information
- Status:
- Complete
- Approver:
- Dolph Mathews
- Priority:
- High
- Drafter:
- Dolph Mathews
- Direction:
- Approved
- Assignee:
- Sylvain Afchain
- Definition:
- Approved
- Series goal:
- Accepted for havana
- Implementation:
-
Implemented
- Milestone target:
-
2013.2
- Started by
- Dolph Mathews
- Completed by
- Thierry Carrez
Related branches
Related bugs
Sprints
Whiteboard
Gerrit topic: https:/
Addressed by: https:/
Add index on expires column of the SQL token Backend
(?)
