Closed Bug 465360 Opened 16 years ago Closed 13 years ago

Add full-text index to frames.signature

Categories

(Socorro :: General, task, P1)

Product:
Socorro
Component:
General
Type:
task

Tracking

(Not tracked)

Status:
RESOLVED DUPLICATE of bug 651279
Milestone:
Future

People

(Reporter: morgamic, Unassigned)

References

Details

(Whiteboard: [search])

Frames.signature needs a full-text index in order to improve search performance for queries like the ones still causing timeouts in bug 444749. Need to: * determine if this is even feasible given the size of the result set and reports:frames cardinality (10:1) * if not, find a way to flatten frame data
Blocks: 444749
Severity: normal → critical
Priority: -- → P1
Blocks: 454872
Full-text may not be the best case since these aren't dictionary words, but we're reading up on the best solution for optimizing this search.
Target Milestone: 0.7 → 0.6
reports.signature is what people are most likely to be interested in, so we should make that really fast. frames.signature is interesting to some people, so it'd be nice if it was possible to query against that, but you can probably restrict to exact matches if it makes life easier.
Target Milestone: 0.6 → Future
Component: Socorro → General
Product: Webtools → Socorro
Whiteboard: [search]
Depends on: 656297
We will get full text indexing on signatures from ES (bug 651279).
Status: NEW → RESOLVED
Closed: 13 years ago
Resolution: --- → DUPLICATE
You need to log in before you can comment on or make changes to this bug.