Page MenuHomePhabricator

Purge old/unused `cusi_case_property` rows
Open, Needs TriagePublic

Description

Per {T433853#12192083}

Suggestion, the idea here implies that it grows without bound. Maybe set a system to purge the values after X years (similarly we drop echo notification after 5 years).

Presumably, no one is looking for "closed cases where users have edited on the same page" as part of their normal workflows. It should be reasonable to drop property rows of cases that have been closed for n years, n TBD by implementer.

Acceptance criteria:
a maintenance script:

  • runs on a schedule
  • checks for properties that belong to stale cases, stale being defined as closed/old enough
  • drops those rows

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

no one is looking for "closed cases where users have edited on the same page" as part of their normal workflows

This is actually an absurdly normal part of cases that go cold, as they might at 5 years. We get cases that show up after a decade of inactivity because someone noticed an overlap in pages edited (and subsequent review of specific edits).

I am not totally certain it makes sense for SI to be tracking this aspect of users at that age since we'll probably either have blocked (or not) and thus associated them directly.

This is actually an absurdly normal part of cases that go cold, as they might at 5 years. We get cases that show up after a decade of inactivity because someone noticed an overlap in pages edited (and subsequent review of specific edits).

Sorry, I meant specifically in the context of Special:SuggestedInvestigations

I am not totally certain it makes sense for SI to be tracking this aspect of users at that age since we'll probably either have blocked (or not) and thus associated them directly.

Which I think we're agreeing on here? But please let me know if this is useful to keep even for closed cases. We're looking to make cases filterable on properties like these.

Yes, I was voicing doubt about whether it was actually valuable in the context of SI (and the further exploration is how valuable it is after N years even for open cases).

(I also read to the end which was "nix them for closed cases" which definitely carry on with that decision either way I think.)