Our most frequent query is by token, and it's not indexed so the DB is doing full table scans quite often, and with 11.5 million rows, that can take time. This will also require that we install South.
Commits pushed to master at https://github.com/mozilla/basket https://github.com/mozilla/basket/commit/53ebfc4988ee17ec8f23036d62e076b86988b2e0 Bug 855415: Add db index to token column. * Reduce token column length to 40 (UUIDs are 36 chars) * Install South. https://github.com/mozilla/basket/commit/d3c62d32c6ab8983adb0c55945e97bb92eb68be6 Merge pull request #31 from pmclanahan/bug-855415-add-token-db-index Bug 855415: Add db index to token column.
Is this in?
It is. Sorry, forgot to close. Thanks.
Status: NEW → RESOLVED
Last Resolved: 5 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.