Closed Bug 564807 Opened 11 years ago Closed 8 years ago

Optimize the directory's gnarly slow DB queries

Categories

(Websites :: plugins.mozilla.org, defect)

defect
Not set
normal

Tracking

(Not tracked)

RESOLVED INCOMPLETE

People

(Reporter: lorchard, Unassigned)

References

Details

(Whiteboard: [2013q1])

To accommodate the fuzzy multidimensional queries required by the search API, the plugin directory makes gnarly DB queries that seem difficult to optimize.  Like these two:

https://bug564567.bugzilla.mozilla.org/attachment.cgi?id=444224

To avoid most of the joins, we could just hit the DB with a query of plugins and releases by mime-type.  Then, take all those results and perform filtering in PHP.  Since the result set from the DB constrained by mime-type should be on the order of 10's of items, this should be not too onerous.

Would still need joins to collect all the columns needed for PHP-side filtering, but they wouldn't be involved in the WHERE clause.  Maybe this will eventually call for some denormalization of the DB
Duplicate of this bug: 564567
Blocks: 573775
Blocks: 811841
Whiteboard: [2013q1]
:lorchard, is this still desired? I see that it was scheduled for q1 2013 back in January, should we make this a priority for q3?
Flags: needinfo?(lorchard)
(In reply to Sheeri Cabral [:sheeri] from comment #2)
> :lorchard, is this still desired? I see that it was scheduled for q1 2013
> back in January, should we make this a priority for q3?

Probably no? I haven't worked on this project in a few of years. Last I heard I think the whole thing was getting rewritten
Flags: needinfo?(lorchard)
OK, I'm resolving incomplete and if it's an issue, someone can re-open or we can make a new bug.
Status: NEW → RESOLVED
Closed: 8 years ago
Resolution: --- → INCOMPLETE
You need to log in before you can comment on or make changes to this bug.