Queries not being cached?

RESOLVED FIXED in 3.3

Status

addons.mozilla.org Graveyard
API
--
major
RESOLVED FIXED
9 years ago
a year ago

People

(Reporter: xb95, Assigned: wenzel)

Tracking

unspecified

Details

Attachments

(1 attachment)

(Reporter)

Description

9 years ago
http://xb95.pastebin.mozilla.org/324320

There are a lot of queries that are being sent against the database multiple times a second that are identical, version checks for the same addons, etc.

(Not sure what else to put here?)

Comment 1

9 years ago
I'm not sure this is the API but seems entirely possible.

Is web server traffic spiking as well?  on what pages?
Severity: normal → major
OS: Mac System 7 → All
Hardware: PocketPC → All
Target Milestone: --- → 3.3
(Assignee)

Comment 2

9 years ago
Created attachment 302170 [details] [diff] [review]
ltrim queries to get rid of leading whitespace

Queries with leading whitespace were not memcached. Ouch.

morgamic, please review.
Assignee: nobody → fwenzel
Status: NEW → ASSIGNED
Attachment #302170 - Flags: review?(morgamic)
Attachment #302170 - Flags: review?(morgamic) → review+
(Assignee)

Comment 3

9 years ago
FIXED in r10123 (trunk) and r10124 (reskin branch). Marking push-needed.
Status: ASSIGNED → RESOLVED
Last Resolved: 9 years ago
Keywords: push-needed
Resolution: --- → FIXED

Comment 4

9 years ago
Woo good find!
(Assignee)

Comment 5

9 years ago
heh, thanks -- I just want to be good friends with the database, that's all ;)
This is live.
Keywords: push-needed
Product: addons.mozilla.org → addons.mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.