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