engels74/obzorarr 0.1.1

v0.1.1

on GitHub

Performance Improvements

Database Optimizations

• Added indexes on play_history table (account_id, viewed_at, composite index)
• Added lookup index on cached_stats table
• Replaced .length with SQL COUNT() aggregate for play history counts
• Fixed N+1 query issue in top viewers calculation
• Batched metadata writes inside transactions to reduce overhead

SSE Stream Efficiency

• Sync status stream: Adaptive polling (500ms active → 2000ms idle)
• Log stream: Exponential backoff polling (1s → 5s)
• Reduced SSE idle network traffic by approximately 75%

Performance Results

Full Changelog: 0.1.0...0.1.1