david on Nostr: Using #neo4j apoc.load.json and apoc.periodic.iterate with a batch size of 1000 I can ...
Using #neo4j apoc.load.json and apoc.periodic.iterate with a batch size of 1000 I can transfer about 100k events from strfry in around 45 minutes. More specifically: I create 967 NostrUser nodes, 102602 NostrEvent nodes, and all the AUTHOR edges. Each event node is initialized with properties: event_id, kind, created_at, and author. Each user node is initialized with property: pubkey.
Jay [MOVED HERE] (npub10mt…27hf) is 45 min reasonable or should I be expecting a lot better performance than that?
Published at
2025-02-09 04:41:22Event JSON
{
"id": "8fbb005b53bfc459ccf009385eaa62789b536a5498d919544f34bf78444cc1e9",
"pubkey": "e5272de914bd301755c439b88e6959a43c9d2664831f093c51e9c799a16a102f",
"created_at": 1739076082,
"kind": 1,
"tags": [
[
"t",
"neo4j"
],
[
"p",
"7ed7d5c3abf06fa1c00f71f879856769f46ac92354c129b3ed5562506927e200"
]
],
"content": "Using #neo4j apoc.load.json and apoc.periodic.iterate with a batch size of 1000 I can transfer about 100k events from strfry in around 45 minutes. More specifically: I create 967 NostrUser nodes, 102602 NostrEvent nodes, and all the AUTHOR edges. Each event node is initialized with properties: event_id, kind, created_at, and author. Each user node is initialized with property: pubkey.\n\nnostr:npub10mtatsat7ph6rsq0w8u8npt8d86x4jfr2nqjnvld2439q6f8ugqq0x27hf is 45 min reasonable or should I be expecting a lot better performance than that?",
"sig": "bd905694e60c9d6d2a888630393559be7c1956f55d77e0d620611d86ccb90bae40eae20036f6d82403207eeb45295f1ca0a40402288d901d1b6b11859e050902"
}
