Closed Bug 483024 Opened 12 years ago Closed 12 years ago

Top Crashers By Url query performance bad, all materialized views should use ids for dimension instead of value

Categories

(Socorro :: General, task)

x86
macOS
task
Not set
normal

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: ozten, Unassigned)

Details

topcrashbyurl.py line 386
   selSql = """/* soc.crn tcburl sel urlindim */
          SELECT id, url FROM urldims WHERE url IN ('%s');"""

This phase of the mtbf and topcrashersbyurl should use dimension ids instead of dimension values and then do a IN or a JOIN on the results.

Bonus Points: get the last insert id, instead of selecting them after the insert.
Status: NEW → RESOLVED
Closed: 12 years ago
Resolution: --- → FIXED
Component: Socorro → General
Product: Webtools → Socorro
You need to log in before you can comment on or make changes to this bug.