# Making complex JSON 58x faster, use 3,300x less memory, in ClickHouse

DevFeed: [Making complex JSON 58x faster, use 3,300x less memory, in ClickHouse](<https://devfeed.tech/articles/making-complex-json-58x-faster-use-3-300x-less-memory-in-clickhouse-5359.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/json-data-type-gets-even-better>)

Author: Pavel Kruglov

Published: 2025-10-09T00: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>), [data](<https://devfeed.tech/topics/data.md>), [Amazon S3](<https://devfeed.tech/topics/amazon-s3.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [data](<https://devfeed.tech/tags/data.md>), [json](<https://devfeed.tech/tags/json.md>), [memory](<https://devfeed.tech/tags/memory.md>), [performance](<https://devfeed.tech/tags/performance.md>), [s3](<https://devfeed.tech/tags/s3.md>), [serialization](<https://devfeed.tech/tags/serialization.md>), [storage](<https://devfeed.tech/tags/storage.md>)

## AI overview

The article explains how ClickHouse v25.8 improves performance for workloads containing thousands or tens of thousands of unique JSON paths. New shared-data serializations, including bucketed shared data, allow ClickHouse to read only the relevant data instead of scanning an entire shared column, reducing data scanned and memory usage while avoiding excessive file-system overhead.

## Source excerpt

The latest changes to the JSON data type in v25.8 make ClickHouse the leader in analytics over JSON data.