aaron on Nostr: sqlite just magically stopped using the obvious index it has been using since the ...

sqlite just magically stopped using the obvious index it has been using since the dawn of my relay taking queries from <1ms to >200ms

easy fix is to frequently `pragma analyze` but something about this makes me want to capitulate + cut over to an embedded kv - sql isn’t giving enough to pay for this