Closed Bug 547028 Opened 14 years ago Closed 14 years ago

Sphinx should use new "last_updated" field on addons table

Categories

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

Product:
addons.mozilla.org Graveyard
Component:
Search
Platform:
x86
macOS
Type:
defect
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: davedash, Assigned: davedash)

Details

Currently sphinx does a nasty join to get the last_updated date.  We should use the new denormalized last_updated field on the addons table instead.  This will speed up indexing, and make for a cleaner config file.
Assignee: nobody → dd
Fixed in 5.8.

Notes to QA: in theory this should improve date based sorting as we now have a consistent field to sort against.
Status: NEW → RESOLVED
Closed: 14 years ago
Resolution: --- → FIXED
Product: addons.mozilla.org → addons.mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.