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

[Alberto Donato]

** Merge proposal linked:
   https://code.launchpad.net/~ack/ubuntu/+source/django-piston3/+git/django-piston3/+merge/372061

-- 
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