Alex Gleason on Nostr: I have come to the same conclusion as nostr-rs-relay that there needs to be a `kind` ...
I have come to the same conclusion as nostr-rs-relay that there needs to be a `kind` and `created_at` columns on the tags table for performance to be good.
"Alex, why are tag queries on Ditto slow?"
"Because there's 34 million fucking tags"
Published at
2024-07-16 16:02:48Event JSON
{
"id": "36e5395b9f0a7f311d7eb6d40dd5faa116285fd178fa9e711d807b637016c136",
"pubkey": "0461fcbecc4c3374439932d6b8f11269ccdb7cc973ad7a50ae362db135a474dd",
"created_at": 1721138568,
"kind": 1,
"tags": [
[
"q",
"7d0bd4d64b6c9cfc3b431c3b783f229f64ea08278739075ce70aa05b88f14dfd"
],
[
"p",
"0461fcbecc4c3374439932d6b8f11269ccdb7cc973ad7a50ae362db135a474dd"
]
],
"content": "I have come to the same conclusion as nostr-rs-relay that there needs to be a `kind` and `created_at` columns on the tags table for performance to be good.\n\nnostr:note1059af4jtdjw0cw6rrsahs0eznajw5zp8suuswh88p2s9hz83fh7s72k7mv",
"sig": "1dd57e1477e47c10df310a8ae9f8f77b72ed6321df56cf078f68984df83045823074788880c276784a567c655d1766ead622758fb32ecfb658f78bcdab2abbcf"
}