DEV Community

Discussion on: Creating a ClickHouse cluster - Part I: Sharding

Collapse
 
datasleek profile image
Franck Leveneur

Yeah, been testing Clickhouse it's fast but when you start joining tables with Millions of rows, Clickhouse falls apart (and even runs out of memory).
You should checkout Singlestore (full cluster solution, support memory and column store engine) and lots of analytical features. Not to mention pipelines, which can be used to ingest from S3, Kafka with just few line of SQL.
Planning to post benchmark based on TPCH between Singlestore and Clickhouse.