Skip to main content
Version: Latest-3.5

SSB Flat-table Benchmarking

Star schema benchmark (SSB) is designed to test basic performance metrics of OLAP database products. SSB uses a star schema test set that is widely applied in academia and industry. For more information, see Star Schema Benchmark.

ClickHouse flattens the star schema into a wide flat table and rewrites the SSB into a single-table benchmark. For more information, see Star schema benchmark of ClickHouse

This test compares the performance of StarRocks, Apache Druid, and ClickHouse against SSB single-table datasets.

Test conclusions

The test is performed on an OLAP table in a shared-nothing StarRocks cluster, together with ClickHouse and Apache Druid, against the same dataset.

Based on the results from 13 queries performed on the 100 GB SSB-Flat dataset, StarRocks has an overall query performance 1.87x that of ClickHouse and 4.75x that of Apache Druid. The unit of the results are milliseconds.

SSB-SR

Test preparation

Hardware

StarRocks, Apache Druid, and ClickHouse are deployed on hosts of the same configurations - AWS m7i.4xlarge.

Spec
Instance Number5
vCPU16
Memory (GiB)64
Network Bandwidth (Gbps)Up to 12.5
EBS Bandwidth (Gbps)Up to 10

Software

StarRocksClickHouseApache Druid
Cluster SizeOne FE, Three BEsThree nodesOne Master Server, one Query Servers, and three Data Servers
Version3.5.025.3.3.4233.0.0
Release Date2025.6.132025.4.222025.4.29
ConfigurationDefaultDefaultDefault

Test results

The following table shows the performance test results on 13 queries. The unit of query latency is milliseconds. All queries are warmed up 1 time and then executed 3 times to take the average value as the result. ClickHouse vs StarRocks and Druid vs StarRocks in the table header means using the query response time of ClickHouse/Druid to divide the query response time of StarRocks. A larger value indicates better performance of StarRocks.

QueryStarRocksClickHouseDruidClickHouse vs StarRocksDruid vs StarRocks
SUM992185847101.874.75
Q0130493301.6311.00
Q0216312601.9416.25
Q0326292501.129.62
Q041431974201.382.94
Q051201794401.493.67
Q06631583202.515.08
Q071332495101.873.83
Q08901973802.194.22
Q09861503501.744.07
Q1020332501.6512.50
Q111563405502.183.53
Q12661333302.025.00
Q13431133202.637.44