Closed Bug 416403 Opened 16 years ago Closed 16 years ago

Queries not being cached?

Categories

(addons.mozilla.org Graveyard :: API, defect)

Product:
addons.mozilla.org Graveyard
Component:
API
Type:
defect
Priority:
Not set
Severity:
major

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: xb95, Assigned: wenzel)

Details

Attachments

(1 file)

ltrim queries to get rid of leading whitespace
553 bytes, patch
morgamic
: review+
Details | Diff | Splinter Review 
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?)
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
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+
FIXED in r10123 (trunk) and r10124 (reskin branch). Marking push-needed.
Status: ASSIGNED → RESOLVED
Closed: 16 years ago
Keywords: push-needed
Resolution: --- → FIXED
Woo good find!
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.

Attachment

General

Creator:
Created:
Updated:
Size: