i'm surprised how fast it's saying the events were published tho. if you use the import tool on a trove of events of around 117k, it takes about 15 seconds to swallow the whole lot, which means it's more like 8000 events/s
but maybe you have faster, next generation hardware, my pc has like 3 years ago tech in it. i've used a hetzner server that was about 3-4x faster at everything in my recent previous project with a large database iteration (comparing a set of 1000 records to each other, N(N-1) operations, something like, what was it, 400,000 operations in total. this included standard library JSON decoding. i was going to optimize that stuff with a decoder cache but it was working well enough for processing one row at a time.
mleku
npub1fj…mleku
2025-08-05 17:35:29 UTC
in reply to nevent1q…d5jd
Author Public Key
npub1fjqqy4a93z5zsjwsfxqhc2764kvykfdyttvldkkkdera8dr78vhsmmlekuPublished at
2025-08-05 17:35:29 UTCEvent JSON
{
"id": "237468fe89f6ab880d3e0a81d47035adeb48e1c986ed3eeb2a9a04d9527bee6c",
"pubkey": "4c800257a588a82849d049817c2bdaad984b25a45ad9f6dad66e47d3b47e3b2f",
"created_at": 1754415329,
"kind": 1,
"tags": [
[
"e",
"2d45bf2ba69ed70b72776c391d791953948e1b7b310e4b469b0a585da980a570",
"wss://nos.lol/%20wss://nostr.land/%20%20avatar%20wss://nostr.wine/%20%20avatar%20wss://purplerelay.com/%20wss://relay.damus.io/%20wss://relay.snort.social/",
"root",
"fd208ee8c8f283780a9552896e4823cc9dc6bfd442063889577106940fd927c1"
],
[
"e",
"1fd862d88965d3d2f6e408c31333b07220692125a25dea3060b6de1c14626802",
"wss://realy.mleku.dev/",
"reply",
"4c800257a588a82849d049817c2bdaad984b25a45ad9f6dad66e47d3b47e3b2f"
],
[
"p",
"fd208ee8c8f283780a9552896e4823cc9dc6bfd442063889577106940fd927c1"
],
[
"p",
"ee07e263a68afd3c9cc25bec9bde31c25b4156e71466bb3df9185be11be01122"
]
],
"content": "i'm surprised how fast it's saying the events were published tho. if you use the import tool on a trove of events of around 117k, it takes about 15 seconds to swallow the whole lot, which means it's more like 8000 events/s\n\nbut maybe you have faster, next generation hardware, my pc has like 3 years ago tech in it. i've used a hetzner server that was about 3-4x faster at everything in my recent previous project with a large database iteration (comparing a set of 1000 records to each other, N(N-1) operations, something like, what was it, 400,000 operations in total. this included standard library JSON decoding. i was going to optimize that stuff with a decoder cache but it was working well enough for processing one row at a time.",
"sig": "7468c0041fa92fc7a72ce0046cdeee11a69c796e11cec565be3d3c71c7c34857f0b8880437754bc20a2f5b8f181c6981b627a0c75db6783c8a2649aa30333b28"
}