Frigate NVR Updates: Database Query Indexes
A single pull request from contributor jvallery adds targeted database indexes to fix slow, time-ordered API queries in Frigate's Events UI, addressing a query planning problem rather than a data size problem.
Duration: PT1M41S
Episode overview
This episode is a short developer briefing from Frigate NVR Updates.
It explains recent repository work in plain language.
- Show: Frigate NVR Updates
- Published: 2026-08-21T13:17:01Z
- Audio duration: PT1M41S
Transcript excerpt
This excerpt keeps the crawler page concise. Listen to the episode or use the RSS feed for the full update.
Good morning. It's August 21st, 2026, and this is Frigate NVR Updates.
Today's focus is a single but consequential change: database performance for large, long-running Frigate installations.
Pull request 24043, from contributor jvallery, tackles slow SQLite query performance in the Events UI. The investigation here is worth noting. The instinct with a growing database is to blame size — and this one is sizable, close to two gigabytes with hundreds of thousands of event, review, and timeline rows across…
The fix is targeted: new indexes designed specifically to support time-ordered API queries. That's a meaningful distinction for anyone running Frigate at scale. It means the pain wasn't inevitable as your retention grows — it was a missing index problem, which is a much more tractable fix than needing to prune data…
For developers and self-hosters watching this, the practical takeaway is that installations with long retention windows and many cameras are the ones most likely to feel this improvement. If you've noticed sluggish loading in the Events or Review interface, this change is aimed directly at that symptom.
What's next: watch for this landing in a release and keep an eye on…
Nearby episodes from Frigate NVR Updates
- Weekly Recap - Multi-Model Support & Container Security Hardening
- Container Hardening and Recording Reliability
- Locking Down the API
- Frame Handling Fix and Config Consolidation
- A Deadlock Fix and a New Detector
- Multi-Model Support and Storage Reliability
- MQTT Refactor and Beta Polish
- Weekly Recap - Runtime Flexibility & Security Hardening