:blobcatverified2: on Nostr: I wrote the last 2 hours one SQL Query that actually works pretty well... 10 seconds ...
I wrote the last 2 hours one SQL Query that actually works pretty well...
10 seconds to update 1m entries
Published at
2023-12-07 14:21:15Event JSON
{
"id": "e36c818793a21af4feede6bb423c3250aa24e2353446382c9265155c0c6af6d7",
"pubkey": "304bca196ea40de81c5e94e588eeb5568ec36f4aa54cd073bde05f8939db0645",
"created_at": 1701958875,
"kind": 1,
"tags": [
[
"proxy",
"https://blob.cat/objects/94640b13-c1b4-431b-a0fa-d904e145a32c",
"activitypub"
]
],
"content": "I wrote the last 2 hours one SQL Query that actually works pretty well... \n10 seconds to update 1m entries",
"sig": "3b18f427fb2a921f6b1774a350b44b08ee07b32339fc8e48b7de3e9bedfc2bfda2e356395bf49baaf8e86896ebbb4878bd925096d68e1162260e900dcea8f5ae"
}