3 ms·
Cassandra and ClickHouse are designed to do different things. To flip things around, have you compared the latency of a single-row update or delete in Cassandra
by peferron 6y ago
Cassandra and ClickHouse are designed to do different things. To flip things around, have you compared the latency of a single-row update or delete in Cassandra vs ClickHouse?
- hodgesrm 6y agoOr the fact that Cassandra uses consistent hashing to distribute data automatically across hosts. My company supports ClickHouse, but there are many use cases where it's simply not the right solution.
- MrBuddyCasino 6y agoIf you care about the latency of a single row update or delete, Clickhouse is definitely the wrong tool for the job. First, it doesn’t really have deletes(afaik). Second, you need to batch updates aggressively to get good throughput. But you’re right C* and CH are designed to do different things. I just found the difference in general performance across everything (startup, schema changes, throughput, query performance, optimization opportunities) to be quite pronounced. One feels like a race car, the other not so much.