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 […]

[Original post on momostr.pink]

Original post on coracle.social

New features coming to #nostrdb soon:

1. Indexable cursor api

This will allow you to perform resumable and paginated queries in realtime. This will enable infinite scroll on arbitrary queries, you will also be able to index/seek into these queries at any point, which will be useful for building…