[Bug 1842043] Re: The Nonce model needs an index

[Ubuntu Foundations Team Bug Bot]

The attachment "diff.diff" seems to be a debdiff.  The ubuntu-sponsors
team has been subscribed to the bug report so that they can review and
hopefully sponsor the debdiff.  If the attachment isn't a patch, please
remove the "patch" flag from the attachment, remove the "patch" tag, and
if you are member of the ~ubuntu-sponsors, unsubscribe the team.

[This is an automated message performed by a Launchpad user owned by
~brian-murray, for any issue please contact him.]

** Tags added: patch

-- 
You received this bug notification because you are a member of Ubuntu
Sponsors Team, which is subscribed to the bug report.
https://bugs.launchpad.net/bugs/1842043

Title:
  The Nonce model needs an index

Status in django-piston3 package in Ubuntu:
  In Progress

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.

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/django-piston3/+bug/1842043/+subscriptions