when I finally benchmark #nostrdb and it performs 1 million queries on a database of 1 million events in under a second 
Thread
Login to reply
Replies ()
lmdb is bonkers
npub1tt4j2zeswksjh5z7zmy283qd4yd920afy9j28xg45wsxzhl9rpjqrex9ud
I’m sure he’ll be like “that seems slow”. I haven’t optimized it yet!
This is good for Nostr. 🤙
1 microsecond seek time.
FriendlyElec NanoPi R6s (RockChip RK35588)
root@FriendlyWrt /u/o/nostrdb (master)# ./bench 1000000
benching parser 1000000 times
ns/run 217153
ms/run 0.217153
ns 217153545895
ms 217153
I did a fresh pull/build beforehand. (git pull, make)
there are 3 benches. That one doesn’t query anything.
I’m using bench-ingest-many the first run will take around 15 seconds to verify and import 1 million entries into the db.
The second run should try to import but skip duplicates, so it does about 1 million queries (plus some extra stuff like parse ids).
On my old laptop it takes about 1 second. But on my m2 querying is actually slower by 3 seconds which was surprising. Still looking into why 🤔
😳😏
Just imagine not earning satoshis while playing solitaire!
Follow us and check our latest habla post to learn more:
Habla
Club Bitcoin Solitaire – Earn Satoshis while playing - (L)Earn Bitcoin
Are you a fan of card games and interested in cryptocurrencies? Imagine if you could use your solitaire skills to earn Satoshis. In this article, w...