girinovey on Nostr: Abou indexes, observing the queries most commonly used, i'll have an index for id and ...
Abou indexes, observing the queries most commonly used, i'll have an index for id and one for author+kind. (author + kind is the most common query i've seen, followed by querying by id)
Published at
2024-10-24 18:09:24Event JSON
{
"id": "5268087c459c5e5615429e2961afef9070514f9ebdbda0e28a73defbe617a0d4",
"pubkey": "3ffac3a6c859eaaa8cdddb2c7002a6e10b33efeb92d025b14ead6f8a2d656657",
"created_at": 1729793364,
"kind": 1,
"tags": [
[
"e",
"80a2885047628b116d72245192bdf3e2cfbbecfae5e828fa6500d5b1dd7aaf11",
"",
"root"
],
[
"e",
"a97d17383c9f12b5195a1276d2b5bbf9d569817da1f7c0044b402589764b313f",
"",
"reply"
],
[
"p",
"3ffac3a6c859eaaa8cdddb2c7002a6e10b33efeb92d025b14ead6f8a2d656657"
],
[
"p",
"e2ccf7cf20403f3f2a4a55b328f0de3be38558a7d5f33632fdaaefc726c1c8eb"
]
],
"content": "Abou indexes, observing the queries most commonly used, i'll have an index for id and one for author+kind. (author + kind is the most common query i've seen, followed by querying by id)",
"sig": "f3dadec7c8d412b85a3ff60a5bdd7694954582e1f23fff29f4024f47ecc1a53e11e4318dc851def9c4d26aa3e747cb76157554a666aa3ea69b31149c7357a6b1"
}
