Record🤔

uri:

"at://did:plc:bvdrfwiamgi5leqs63q2duro/app.bsky.feed.post/3l47g3t525622"

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:

  

  View blob content

  $type:

  "blob"

  ref:

  $link:

  "bafkreiaobz7kkrgj5jlj4aim5q4aplpdr7nw3ytwng4cnibgfpzrbfkdom"

  mimeType:

  "image/jpeg"

  size:

  438636

  aspectRatio:

  width:

  1136

  height:

  444

langs:

• "en"

reply:

root:

cid:

"bafyreierwwtlwubijgrmkipbcntvmcuc7lpekgr6qzrxlpp6eykg6jdz3a"

uri:

"at://did:plc:bvdrfwiamgi5leqs63q2duro/app.bsky.feed.post/3l43d67ts5z2e"

parent:

cid:

"bafyreigmlkaoj4newdmgjvksa5t7tvj2fzigzcnt6nldtzof4kegznlhxy"

uri:

"at://did:plc:bvdrfwiamgi5leqs63q2duro/app.bsky.feed.post/3l43ddwstnm23"

createdAt:

"2024-09-15T16:33:19.127Z"