jb55 on Nostr: I wasn't happy that generating dashboard reports was taking over a second, so i ...
I wasn't happy that generating dashboard reports was taking over a second, so i implemented a new query plan optimized for efficient scans over all notes in #nostrdb
i've reached the limit of physics for how fast i can make the #notedeck dashboard: down to 288 milliseconds (0.28 seconds) for 1.46 million notes
at least this should scale nicely when I dump 40 million more notes into my local node.
i have a performance addiction problem...
Published at
2026-01-16 01:52:54 UTCEvent JSON
{
"id": "f0681abc0d2321ae52c4c4ca93c8434a678a0d973b13a5bbad49355eac9afd64",
"pubkey": "32e1827635450ebb3c5a7d12c1f8e7b2b514439ac10a67eef3d9fd9c5c68e245",
"created_at": 1768528374,
"kind": 1,
"tags": [
[
"client",
"Damus Notedeck"
],
[
"t",
"nostrdb"
],
[
"t",
"notedeck"
]
],
"content": "I wasn't happy that generating dashboard reports was taking over a second, so i implemented a new query plan optimized for efficient scans over all notes in #nostrdb\n\ni've reached the limit of physics for how fast i can make the #notedeck dashboard: down to 288 milliseconds (0.28 seconds) for 1.46 million notes\n\nat least this should scale nicely when I dump 40 million more notes into my local node.\n\ni have a performance addiction problem...\n\nhttps://jb55.com/s/dashboard-perf.png\nhttps://jb55.com/s/54d663b387720f45.png",
"sig": "c2f24bdb96ba072b43a6d87ccb473d414322c33bf418b00b94ee2cccfa26a6693e9be097490d3c0ff7103da241d125381aab8dba0811f790adaccfe05df7127a"
}
