Company
Date Published
Author
Al Brown and Tom Schreiber
Word count
1489
Language
English
Hacker News points
None

Summary

A public benchmark originally designed to test join-heavy SQL queries on Databricks and Snowflake was used to evaluate the performance of ClickHouse Cloud, revealing that ClickHouse was faster and more cost-effective across various scales, from 721 million to 7.2 billion rows. The benchmark involved running 17 SQL queries, most of which included joins, without any special tuning or rewriting, on similar instance sizes. The results demonstrated that ClickHouse consistently outperformed the alternatives, showing significant improvements in speed and cost, even as the dataset size increased. ClickHouse's enhancements over the past six months have resulted in dramatically better join performance, and future tests, including a full TPC-H benchmark, aim to further showcase ClickHouse's capabilities in handling complex joins. The benchmark setup and results are fully reproducible, with resources available on GitHub for those interested in testing ClickHouse Cloud against other platforms.