If you are doing relational database queries, yes it’s kinda slow.
If you are doing key-value database lookups (LMDB), probably faster.
Sacrifice compute for storage or viceversa. The trade offs for dev life.
louislibre / Louis Libre
npub1np…lljja
2023-04-18 14:55:46
in reply to nevent1q…7c9l
Author Public Key
npub1npd8c6cww4gg446vgygt9efdlwnvufsx8kqtegsc2e9apqa89wvsklljjaPublished at
2023-04-18 14:55:46Event JSON
{
"id": "beb4cc0b738438cbb33da1f4cd17f3ed825b2066508387260c8aa4104d075bb0",
"pubkey": "985a7c6b0e75508ad74c4110b2e52dfba6ce26063d80bca218564bd083a72b99",
"created_at": 1681829746,
"kind": 1,
"tags": [
[
"e",
"d7f36f2e5e8b2f0c93fbcde6c24b6c0ea1f70df24ee6383650e6fc7100396116"
],
[
"e",
"342bfc16cae216fa89f01798eb28c11ae9b917aa53dcbf0535e22efc80a6c0de"
],
[
"p",
"132f5f2b368b4c6d04002efcc9058fc8aecacc88bdd1a67d4785012f04905181"
],
[
"p",
"75da94027ad408bc2faffeb1e67d71babe8d78d89c3620da212303b877a65b5c"
],
[
"p",
"32e1827635450ebb3c5a7d12c1f8e7b2b514439ac10a67eef3d9fd9c5c68e245"
],
[
"p",
"b2dd40097e4d04b1a56fb3b65fc1d1aaf2929ad30fd842c74d68b9908744495b"
]
],
"content": "If you are doing relational database queries, yes it’s kinda slow.\n\nIf you are doing key-value database lookups (LMDB), probably faster.\n\nSacrifice compute for storage or viceversa. The trade offs for dev life.",
"sig": "66a2e1d9b941ce4e2202ce736dbf6b20d75b9e1378a63173a8859eaab629d612c53fee6f60221aae28c0fd0bf98cd540b395135b100d36cd06bf8cfed7ab1117"
}