BASE 44 ORDER: Add volatility score column, partial index, LLM prioritization, 5-min timer, cache top 100 — E8 Intelligence Research

Abstract

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1153] Add volatility_compression_score column with window function on created_at/content_length. Create partial index on (score,status) where score<0.5 and status='pending_llm'. Modify LLM batching loop to prioritize score<0.5 items. Add systemd timer updating new rows every 5 min. Cache top 100 scores. MERLIN: Understood. I'll add the volatility_compression_score column computed via window function on created_at/content_length, create the partial index on (score,status) where score<0.5 and status='pending_llm', modify the LLM batching loop to prioritize low-score items, set up a systemd timer to refresh new rows every 5 minutes, and cache the top 100 scores. The swarm will implement these changes and verify the index and timer are active. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com