Closed Bug 651559 Opened 14 years ago Closed 14 years ago

Use statsd to time the usernames API

Categories

(support.mozilla.org :: Users and Groups, task)

Product:
support.mozilla.org
Component:
Users and Groups
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
VERIFIED FIXED
Milestone:
2011-06-21

People

(Reporter: jsocol, Assigned: jsocol)

References

Details

Another thing to time with statsd once we have graphite: how long the usernames API queries take. I'm concerned that the Q(profile__name__istartswith=pre) part of the query may be excruciatingly slow.
I'd put an index (with a lowercase collation) on the profile.name field. Then it should be right quick.
Blocks: 663502
Assignee: nobody → james
Target Milestone: 2011Q2 → 2011-06-21
https://github.com/jsocol/kitsune/commit/742b295
Status: NEW → RESOLVED
Closed: 14 years ago
Resolution: --- → FIXED
Please add verification steps or mark as [qa-], thanks
You should see stats.timers.srao.users.api.usernames.search in the SJC Graphite. Might have to visit the site first to generate some data.
Verified data points display on SJC graphite.
Status: RESOLVED → VERIFIED
You need to log in before you can comment on or make changes to this bug.