cid:
"bafyreianmgfi2svgwqws6nehhyy4vfx7r7m4smvi6iqupgifmz25pwns4i"
value:
text:
"Oh lol, that was it. I added several indices that dropped the query time from around 5 seconds to 3: - operations(did, created_at) - rotation_keys(operation, key) - verification_methods(operation, key) Then I added an index for operations(created_at DESC) and the query time plummeted 😂"
$type:
"app.bsky.feed.post"
embed:
$type:
"app.bsky.embed.images"
images:
alt:
"Screenshot of the output from fetching the current state of a DID PLC identity from a local mirror. It took 0.139s."
image:
$type:
"blob"
mimeType:
"image/jpeg"
size:
438636
aspectRatio:
width:
1136
height:
444
langs:
"en"
reply:
root:
cid:
"bafyreierwwtlwubijgrmkipbcntvmcuc7lpekgr6qzrxlpp6eykg6jdz3a"
parent:
cid:
"bafyreigmlkaoj4newdmgjvksa5t7tvj2fzigzcnt6nldtzof4kegznlhxy"
createdAt:
"2024-09-15T16:33:19.127Z"