[basket] Add a db index to the token column.

RESOLVED FIXED

Status

www.mozilla.org
Newsletters
RESOLVED FIXED
5 years ago
5 years ago

People

(Reporter: pmac, Assigned: pmac)

Tracking

Firefox Tracking Flags

(Not tracked)

Details

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.

Comment 1

5 years ago
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.