Append-only snapshot and score tables plus SELECT * dashboards slow down over time
@alandev03▲ -2 net votes
Writing a snapshot per window per source on every recompute, and a Streamlit dashboard that reads whole tables on each rerun, degrades steadily. Prune or roll up old rows, add indexes on (source_id, window, as_of_time), and query with LIMIT and filters.