Closed Bug 542489 Opened 15 years ago Closed 13 years ago

[shipping] Add archive state for signoffs

Categories

(Webtools Graveyard :: Elmo, defect, P3)

x86
All
defect

Tracking

(Not tracked)

RESOLVED WONTFIX

People

(Reporter: zbraniecki, Unassigned)

References

Details

(Keywords: perf, Whiteboard: schema-change)

In order to reduce the amount of work we have to do on each query, we could use "archive" flag on signoff table and filter out everything that does have it set to True. The logic will be bundled in: * on accept mark all older accepted signoffs as archive * on reject find a previous one and unarchive it That sounds like a good tradeoff.
Putting into P3 right now, but we should bump this as we get more data.
Keywords: perf
Priority: -- → P3
Summary: Add archive state for signoffs → [dashboard][shipping] Add archive state for signoffs
Whiteboard: schema-change
Component: Infrastructure → Elmo
Product: Mozilla Localizations → Webtools
QA Contact: infrastructure → elmo
Summary: [dashboard][shipping] Add archive state for signoffs → [shipping] Add archive state for signoffs
Version: unspecified → 1.0
This doesn't work this way anymore with the new release scheme. The aurora signoffs are a continuous scheme, we may be able to optimize by adding a "first good signoff" de-normalization to AppVersion post data1.1.
Depends on: data1.1
We're now query-ing over Actions instead of SignOffs. Thus, this seems to be a non-good optimization, and we're also querying in the other direction, and reduce the locales to walk over. Most of this is done, and conceptually, it doesn't apply as is, thus resolving WONTFIX.
Status: NEW → RESOLVED
Closed: 13 years ago
Resolution: --- → WONTFIX
Product: Webtools → Webtools Graveyard
You need to log in before you can comment on or make changes to this bug.