StarRocks 2.0 vs ClickHouse: Benchmark Shows Up to 7× Speed Boost
Community testing of StarRocks 2.0 revealed that, across multiple benchmarks—including low‑cardinality queries, SSB workloads, and high‑concurrency scenarios—StarRocks consistently outperformed ClickHouse and Druid, delivering performance gains ranging from 2‑3× to over 7×.
Community Testing Program
After the release of StarRocks 2.0, the community conducted a one‑month testing program. 140 participants submitted 18 complete test reports. Four representative reports were selected for detailed analysis.
Report 1 – Low‑Cardinality Query Performance
Tested StarRocks 1.19.5 and 2.0.1 against ClickHouse 20.4.2.9 under comparable distributed settings.
Without low‑cardinality dictionaries, StarRocks marginally outperformed ClickHouse.
When low‑cardinality optimization was enabled (automatic dictionary encoding for string columns), StarRocks achieved a 2–3× speedup over ClickHouse.
Report 2 – StarRocks vs ClickHouse on the SSB Benchmark
Executed the 13 queries of the Star Schema Benchmark (SSB) on a cluster.
ClickHouse required manual LowCardinality(string) definitions; StarRocks applied low‑cardinality dictionaries automatically.
Overall query throughput of StarRocks was 4.89× that of ClickHouse.
In typical low‑cardinality aggregation scenarios, StarRocks was 2.2× faster.
Report 3 – Impact of Version Upgrade (1.18 → 2.0.1)
On a table with 1 million rows, query latency dropped from >5 s to sub‑second after upgrading to 2.0.1 with global low‑cardinality dictionary enabled.
On a 10 million‑row table, the same workload showed a 7× performance improvement .
Report 4 – High‑Concurrency Comparison with Druid
Adjusted parallel_exchange_instance_num from the default to 1, raising maximum TPS from 3,430 to 5,625.
Further tuning of bucket count and replica factor increased peak TPS to 19,375, with average response latency of 16.19 ms.
Stress‑test results indicate that StarRocks sustains significantly higher throughput than Druid under comparable concurrency.
Signed-in readers can open the original source through BestHub's protected redirect.
This article has been distilled and summarized from source material, then republished for learning and reference. If you believe it infringes your rights, please contactand we will review it promptly.
StarRocks
StarRocks is an open‑source project under the Linux Foundation, focused on building a high‑performance, scalable analytical database that enables enterprises to create an efficient, unified lake‑house paradigm. It is widely used across many industries worldwide, helping numerous companies enhance their data analytics capabilities.
How this landed with the community
Was this worth your time?
0 Comments
Thoughtful readers leave field notes, pushback, and hard-won operational detail here.