Event JSON
{
"id": "ab11a47efcaf8e2b0a1e52b83b0d19f4f895fffe0af4afa62e61a58d8f924ca9",
"pubkey": "289ae2d33f38610e269397f036c704bb8c7023e8efc9cf56fc3110c72c78b354",
"created_at": 1691773295,
"kind": 1,
"tags": [
[
"p",
"a3bae9d9efbe9099b83661bc1f5719f9f842957f28b5b692eb5fbf652f0c0acc",
"wss://relay.mostr.pub"
],
[
"p",
"cde316fed609ec8969c7925309d1c00af277393d61be57980fbf387bf80c6de9",
"wss://relay.mostr.pub"
],
[
"e",
"d012b466733644d7521bd402f0c96b3874450a449d51ef25cc61f029b305daf0",
"wss://relay.mostr.pub",
"reply"
],
[
"content-warning",
"WriteFreely scaling help"
],
[
"proxy",
"https://ruby.social/users/UnderpantsGnome/statuses/110872054720752634",
"activitypub"
]
],
"content": "nostr:npub15wawnk00h6gfnwpkvx7p74cel8uy99tl9z6mdyhtt7lk2tcvptxq2rezxc if you haven't already, turn on slow query logging, it will expose the problem queries and you can tune indexes from there. You didn't mention the DB engine you are using, but MySQL can be an absolute nightmare to do this, I do it all the time.",
"sig": "6b0cd89bc4229bba39ba14062d7db333298d26e1609f0c064b4b45578f5fa3bd0aeb27e0509fb78a19f0de5f47154ddc4134aca96ae4a4cc912a6d165e67203c"
}
