Volleyball Elite Academy development update
|
Volleyball Elite Academy
Stop the duplicate-counter table from growing forever
|
Stop the duplicate-counter table from growing foreverVolleyball 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