# Prove staged HPT2 retained-history scalability

Status: complete
Type: campaign
Updated: 2026-08-27
Next Action: none
Campaign ID: hpt2-prove-staged-retained-history-scalability
Campaign Number: 026
Outcome: Prove with the smallest fail-fast physical ladder that unrelated retained database size does not slow the same customer graph and full-90-day-export work.
Primary Focus Areas: qualification-release
Supporting Focus Areas: hpt-media-logging
Depends On: hpt2-graph-reconstruction-performance-remediation
Decision: none
Detour For: none
Return To: none
Completion Gate: G4 pass criteria are satisfied by exact-candidate, CID-linked Controller A evidence from all three stages.
Completion Evidence: work/evidence/hpt2-staged-retained-history-scalability-20260827.md
Completion Date: 2026-08-27
Completion Order: 12
Disposition: completed
Roadmap: hpt2-qualification
Roadmap Revision: 5
Milestone: M4
Unlocks Gate: G4

## Request

On Controller A, run three clean stages in order: 100 days/144,000 records, 13 calendar months/570,240 records for the 2026-08-27 anchor, and two years/1,051,200 records. At each stage capture required CID evidence, build a chronological store with equivalent newest-90-day content, restore and verify the exact final Release candidate, measure normal open and newest-30-day graph reconstruction, and have the operator run the full newest-90-day export through the customer UI. Credit the target-selected full rolling-window count when a short fixture-to-candidate reflash edge is explicitly measured and independently verified; the owner accepted the 100-day run's 11-minute edge and 129,595 selected rows. Stop on the first failed stage; remediate only that observed failure, repeat it, run one smaller-stage regression, then continue. Stop after G4 is decided.

## App Server Preparation Contract

```json
{
  "campaign_id": "hpt2-prove-staged-retained-history-scalability",
  "completion_evidence": "G4 pass criteria are satisfied by exact-candidate, CID-linked Controller A evidence from all three stages.",
  "exact_resolution": "dispatch-time",
  "execution_shape": "single-bounded-camp",
  "inline_assets": "metadata-only",
  "objective": "Prove with the smallest fail-fast physical ladder that unrelated retained database size does not slow the same customer graph and full-90-day-export work.",
  "schema_version": 1,
  "source_freshness": "required",
  "verification": "orchestrator-exactly-once"
}
```

## Completion Check

G4 pass criteria are satisfied by exact-candidate, CID-linked Controller A evidence from all three stages.
