# Accelerating ClickHouse queries on JSON data for faster Bluesky insights

DevFeed: [Accelerating ClickHouse queries on JSON data for faster Bluesky insights](<https://devfeed.tech/articles/accelerating-clickhouse-queries-on-json-data-for-faster-bluesky-insights-4908.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/accelerating-clickhouse-json-queries-for-fast-bluesky-dashboards>)

Author: Tom Schreiber

Published: 2025-03-19T00:00:00Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [JSON](<https://devfeed.tech/topics/json.md>), [Bluesky](<https://devfeed.tech/topics/bluesky-social.md>), [dashboards](<https://devfeed.tech/topics/dashboards.md>), [data](<https://devfeed.tech/topics/data.md>), [real-time](<https://devfeed.tech/topics/real-time.md>), [SQL](<https://devfeed.tech/topics/sql.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [dashboards](<https://devfeed.tech/tags/dashboards.md>), [json](<https://devfeed.tech/tags/json.md>), [optimization](<https://devfeed.tech/tags/optimization.md>), [performance](<https://devfeed.tech/tags/performance.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [sorting](<https://devfeed.tech/tags/sorting.md>), [speed](<https://devfeed.tech/tags/speed.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

This article presents techniques for accelerating ClickHouse queries over billions of Bluesky JSON documents to keep real-time dashboards responsive. It describes a dataset of more than 4 billion documents and explains how ClickHouse JSON paths, sorting keys, and primary key columns can support sub-100ms query performance with limited CPU and memory.

## Source excerpt

Learn how to guarantee sub-100ms ClickHouse response times for snappy dashboards--no matter how many billions of JSON documents your table holds.