Dustin Dannenhauer on Nostr: Triple checking a new db schema with rollups to avoid full table scans so we can get ...
Triple checking a new db schema with rollups to avoid full table scans so we can get fast, live metrics of DVM activity when we’re at millions of DVM events an hour. Currently at a few hundred per hour.
The future is coming.
Published at
2024-11-28 02:30:56Event JSON
{
"id": "c8a30eb1e6004f30bb034b4c3dfd26a26cdad5e95037f9df58332783443d76b3",
"pubkey": "da18e9860040f3bf493876fc16b1a912ae5a6f6fa8d5159c3de2b8233a0d9851",
"created_at": 1732761056,
"kind": 1,
"tags": [
[
"e",
"489acefe74e7dc3e2dc6f3119d95d7ffb8d01317b65cf1439869fa0e0a2da47d",
"",
"root"
],
[
"p",
"91c9a5e1a9744114c6fe2d61ae4de82629eaaa0fb52f48288093c7e7e036f832"
]
],
"content": "Triple checking a new db schema with rollups to avoid full table scans so we can get fast, live metrics of DVM activity when we’re at millions of DVM events an hour. Currently at a few hundred per hour.\n\nThe future is coming.",
"sig": "d0b85df3f9a3013682f049ebe9667ca222ce7a71b3cdcb9498470eaec3478570c228fd4c5e087df326ef5baaff4db6453bb39c40bf4bbd0f60afca0ca9b4f228"
}
