Closed Bug 855415 Opened 11 years ago Closed 11 years ago

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

Categories

(www.mozilla.org :: Newsletters, defect)

Product:
www.mozilla.org
Component:
Newsletters
Type:
defect
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: pmac, Assigned: pmac)

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.
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
Closed: 11 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.