david on Nostr: Depends on the nature of the query. Lots of strategies to improve efficiency. I ...
Depends on the nature of the query. Lots of strategies to improve efficiency. I haven’t tested this, but I would speculate that getting all the notes in a thread (upstream and downstream of a given kind 1 note) could be implemented more efficiently in a graph db than relational db.
Alternatively: If it takes more memory but is faster, it may still be a worthwhile tradeoff.
Published at
2024-11-26 22:36:36Event JSON
{
"id": "dd6360a36ce855bf09e5d3f9d854b6cb02e8d69147973f7c564d71e47c6b84b1",
"pubkey": "e5272de914bd301755c439b88e6959a43c9d2664831f093c51e9c799a16a102f",
"created_at": 1732660596,
"kind": 1,
"tags": [
[
"e",
"dfad86f303bdbe7af12c7291518a8efe20aac16574ce511184afba43e2cb66a4",
"",
"root"
],
[
"e",
"d2159643a51c69b83c9ed39f40bc24fc482586faa8f278935fca1da03878b769",
"",
"reply"
],
[
"p",
"7cc328a08ddb2afdf9f9be77beff4c83489ff979721827d628a542f32a247c0e"
]
],
"content": "Depends on the nature of the query. Lots of strategies to improve efficiency. I haven’t tested this, but I would speculate that getting all the notes in a thread (upstream and downstream of a given kind 1 note) could be implemented more efficiently in a graph db than relational db.\n\nAlternatively: If it takes more memory but is faster, it may still be a worthwhile tradeoff.",
"sig": "ec7a5ee2f1d609510abdf1c04370f80bfebd2d38985d2c69114758e852e6b66c763173fe8f9b574dd01846cf3613d4d936bb58b42f3533585ef7ae840050c1a6"
}
