September 4, 2026 · 63 views
Turso Rows Read Too High? How One `COUNT(DISTINCT)` Read 10k Rows to Count 200 Staff
A dashboard KPI showed ~200 people scheduled today. Turso Top Queries showed ~10,300 rows read per call — ~4 million in a month. The UI was fine. The access path was not. Here is how a covering index dropped Turso’s reported average from ~10,300 to ~200, and why that number is still Turso’s metric, not SQLite’s.
READ ARTICLE →