ATProto Browser

ATProto Browser

Experimental browser for the Atmosphere

Post

Never scan the same data twice! ClickHouse's new Query Condition Cache quietly supercharges performance for repeated queries—perfect for dashboards and observability. buff.ly/TJE0Pi3 100MB of cache covers up to 6.8T rows, enhancing efficiency without extra tuning.

Apr 1, 2025, 3:03 PM

Record data

{
  "uri": "at://did:plc:7xid6lebvjjyi7u7apq4xen4/app.bsky.feed.post/3llr5evhijs23",
  "cid": "bafyreih22eljpkcxwwfzdihmvhrrqx6suflr54a6pkkeozohr3bebfg324",
  "value": {
    "text": "Never scan the same data twice! ClickHouse's new Query Condition Cache quietly supercharges performance for repeated queries—perfect for dashboards and observability.\n\nbuff.ly/TJE0Pi3\n\n100MB of cache covers up to 6.8T rows, enhancing efficiency without extra tuning.",
    "$type": "app.bsky.feed.post",
    "embed": {
      "$type": "app.bsky.embed.images",
      "images": [
        {
          "alt": "",
          "image": {
            "$type": "blob",
            "ref": {
              "$link": "bafkreiatrpzkaqjv5j25q26xi6jg66xewtgu2s4ihrvehkwm7gftuojot4"
            },
            "mimeType": "image/png",
            "size": 195241
          },
          "aspectRatio": {
            "width": 1276,
            "height": 1098
          }
        }
      ]
    },
    "facets": [
      {
        "index": {
          "byteEnd": 185,
          "byteStart": 170
        },
        "features": [
          {
            "uri": "https://buff.ly/TJE0Pi3",
            "$type": "app.bsky.richtext.facet#link"
          }
        ]
      }
    ],
    "createdAt": "2025-04-01T15:03:09.462Z"
  }
}