peers with monsters on Nostr: I guess I could manually create the index I need but sheesh query goes from ...
(npub1ajw…aj8d) I guess I could manually create the index I need but sheesh
query goes from instantaneous to 20s just from adding an order by in order to paginate on the client side
Published at
2024-04-28 20:45:37Event JSON
{
"id": "f53964ad5ffeb09718f878202f00a6bc1cd695284168c1dea58b485b1f20e1fe",
"pubkey": "fdba142be99884190c65bcf3c42ba9d45d73e2319a076876597d0cee369b4895",
"created_at": 1714337137,
"kind": 1,
"tags": [
[
"p",
"ec9dae9b3dc5951ac7d6cb7070d9c8bcf3998ed72fe4931906e6c7a5ead51ad8",
"wss://relay.mostr.pub"
],
[
"e",
"cdc0982369ac37c70658f31d0e7137ceff7eed1b315bc8433769f355b7488853",
"wss://relay.mostr.pub",
"reply"
],
[
"proxy",
"https://crlf.ninja/objects/0b70b27e-e1e9-4a8c-9403-77bda5f8a4ba",
"activitypub"
]
],
"content": "nostr:npub1ajw6axeack23437kedc8pkwghneenrkh9ljfxxgxumr6t6k4rtvqecaj8d I guess I could manually create the index I need but sheesh\nquery goes from instantaneous to 20s just from adding an order by in order to paginate on the client side",
"sig": "45e212de7e053c5afc4d8445753b03faa865b228d0a48bc51c8c59e626d0fbba311a50ec46bbbcf2f61667d5bd5de770fe36fe5b04a98dfb4ae26fc413cfc52d"
}
