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
Published at
2023-02-08 00:19:01Event JSON
{
"id": "a22921a8c3135b7c773c3979014074c76e1b45268871fe8eb483e2a25ff05012",
"pubkey": "aff9a9f017f32b2e8b60754a4102db9d9cf9ff2b967804b50e070780aa45c9a8",
"created_at": 1675815541,
"kind": 1,
"tags": [],
"content": "sqlite just magically stopped using the obvious index it has been using since the dawn of my relay taking queries from \u003c1ms to \u003e200ms\n\neasy 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",
"sig": "6317a10c25b5ff0558d695982789b0d536009bd1f01c0d056c7d7eb8c70888aa32de368304a967bfbf9a4fbaa5be25c2f88a16e645e7ed4772493d76dc9f76e7"
}
