MDL-60583 webservice: Add index to improve token lookup performance
authorNeill Magill <neill.magill@nottingham.ac.uk>
Thu, 25 Jun 2020 08:11:50 +0000 (09:11 +0100)
committerNeill Magill <neill.magill@nottingham.ac.uk>
Mon, 29 Jun 2020 06:33:12 +0000 (07:33 +0100)
commitb6c7a25d6050ea500aa63ffa00ecf72d07040bd4
tree43dafb42a96385b6a9aed0792176eae917e26a0f
parentc11e2517a77b94c844d88e45b61af4305bbc1cf6
MDL-60583 webservice: Add index to improve token lookup performance

Without this index every webservice call will do a full table scan
when it tries to validate a token. On a busy site with many tokens
this adds unnecessary load to the database.
lib/db/install.xml
lib/db/upgrade.php
version.php