The Nonce model needs an index
Bug #1842043 reported by
Alberto Donato
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
django-piston3 (Ubuntu) |
Won't Fix
|
Low
|
Unassigned |
Bug Description
The Nonce model needs a (ideally unique) index on (token_key, consumer_key, key).
Aside from granting there to be only one entry for each combination, the index will speed up search for nonces when API calls are performed.
Given Nonce entries are never deleted, the table can grow quite big, and doing a full scan to find if there's a matching entry becomes increasingly more costly.
Related branches
~ack/ubuntu/+source/django-piston3:nonce-index-patch
Ready for review
for merging
into
ubuntu/+source/django-piston3:ubuntu/devel
- Björn Tillenius (community): Approve
- Blake Rouse (community): Approve
- git-ubuntu developers: Pending requested
-
Diff: 86 lines (+64/-0)3 files modifieddebian/changelog (+6/-0)
debian/patches/nonce-index.patch (+57/-0)
debian/patches/series (+1/-0)
Changed in django-piston3 (Ubuntu): | |
status: | New → In Progress |
Changed in django-piston3 (Ubuntu): | |
importance: | Undecided → Low |
Changed in django-piston3 (Ubuntu): | |
status: | In Progress → Won't Fix |
To post a comment you must log in.
The patch adds the index to the Nonce model