nice! over what time period is this?
Discussion
ndbnd query -k 1 -l 10000 | jq .created_at | tail -n 2 | datefmt
using filter '{"kinds":[1],"limit":10000}'
10000 results in 8.449777 ms
2026-01-05 08:53
is ndbnd returning sorted events? if the jan 5 timestamp is the oldest that is then roughly 3days of data in the 10k events?
is there any other filtering being done on the events
correct. in nostr when you have a limit, notes are returned newest first. so yes its sorted, as thats how nostr works. no other filtering is done, except for the fact the notes are already prefiltered on notes i would have been subscribed to from my contact list.
thx, we were trying to extrapolate stats with nostr:nprofile1qy2hwumn8ghj7cn9wehjumn0wd68yvfwvdhk6qgdwaehxw309ahx7uewd3hkcqpq8pudjhdhhp2v8gxnkttt00um729nv93tuepjda2jrwn3eua5tf5sur9mx9 of how dead nostr is and just wanted to clarify assumptions in case of nostrdb specifics