Friday, May 8, 2026

Stop the duplicate-counter table from growing forever

Volleyball Elite Academy development update
Volleyball Elite Academy
Stop the duplicate-counter table from growing forever

Stop the duplicate-counter table from growing forever

Volleyball Elite Academy — Development Update • May 8, 2026

--- title: Stop the duplicate-counter table from growing forever ---

Stop the duplicate-counter table from growing forever

## What & Why Task #566 added a new audit table that records every time a coordinator duplicates a teammate's shared SOF saved view. The "Duplicated N× this week" subtitle only ever shows the last 7 days of activity, but rows older than 7 days are still being kept in the table indefinitely. Over time this table will grow unboundedly with data the UI never reads, making backups slower and Postgres queries against the table progressively heavier.

The sibling apply-counter table () already has a scheduled prune sweep that deletes rows older than the visible window — the duplicate table just needs the same treatment.

## Done looks like - A scheduled job deletes rows older than the subtitle's visible window (the same window the apply-counter prune uses) - The "Duplicated N× this week" subtitle still shows accurate counts after the prune runs

## Relevant files - (look for and add a sibling next to it) - (the storage method and the duplicate-count query in ) - (the table)

Volleyball Elite Academy

Reply to this email — we read every reply.

You received this because you have an account with Volleyball Elite Academy.

elitevolleyball.training

No comments:

Post a Comment