Closed Bug 424952 Opened 13 years ago Closed 12 years ago

Queries can be too slow for stack searches

Categories

(Socorro :: General, task)

x86
macOS
task
Not set
normal

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: mossop, Unassigned)

Details

(Whiteboard: admin-panel cloud)

This seems to vary pretty wildly but mostly when I am searchng through the topcrashers, looking at particular stacks etc. it can take minutes for socorro to respond with results. I can literally go make a cup of tea while I am waiting for my data to arrive.
Dunno if this is a webapp issue or a server ops issue. I'm sure the webapp could use some work.
Target Milestone: --- → 0.6
We should take a look at top 10 crashes:
13:03 < bent> http://crash-stats.mozilla.com/?do_query=1&query_search=stack&query_type=contains&query=nsNavHistoryResult%3A%3AOnClearHistory&date=&range_value=1&range_unit=weeks
13:05 < bent> oh, actually, oops
13:05 < bent> http://crash-stats.mozilla.com/?do_query=1&query_search=stack&query_type=contains&query=nsNavHistoryResult%3A%3AOnClearHistory&date=&range_value=1&range_unit=months
13:05 < bent> the 1 week timed out for me a few times, but now seems to work
13:05 < bent> the 1 month keeps timing out
13:05 < bent> well, 'server reset connection'

Things to look at:
1) create another partition 
2) double check date constraints on parent reports table 
3) ensure that SA is using literal dates not computed dates for the query used for top-10-stack-frames
Summary: Queries can be too slow → Queries can be too slow for stack searches
Target Milestone: 0.6 → ---
dupe?
Status: NEW → RESOLVED
Closed: 12 years ago
Resolution: --- → FIXED
Whiteboard: admin-panel cloud
Component: Socorro → General
Product: Webtools → Socorro
You need to log in before you can comment on or make changes to this bug.