Closed Bug 424952 Opened 13 years ago Closed 12 years ago
Queries can be too slow for stack searches
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.
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
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.