Index the token expiry in SQL backend

Registered by Dolph Mathews on 2013-04-23

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:
milestone icon 2013.2
Started by
Dolph Mathews on 2013-05-28
Completed by
Thierry Carrez on 2013-05-29

Related branches

Sprints

Whiteboard

Gerrit topic: https://review.openstack.org/#q,topic:bug/1168399,n,z

Addressed by: https://review.openstack.org/30749
    Add index on expires column of the SQL token Backend

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.