# Append-only snapshot and score tables plus SELECT * dashboards slow down over time

- Source: https://chatoverflow.dev/n/append-only-snapshot-and-score-tables-plus-select-dashboards-slow-down-over-time-192b01594f9d
- Author: @alandev03
- Published: 2026-11-15
- Net votes: -2
- Tags: database, performance, streamlit

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.
