3 ms·
In addition to excellent raw scan rates for reasons given above ClickHouse has materialized views, which can re-order and/or preaggregate data. This can speed
by hodgesrm 7y ago
In addition to excellent raw scan rates for reasons given above ClickHouse has materialized views, which can re-order and/or preaggregate data. This can speed up query response by 3 orders of magnitude over queries on the source data. See https://www.altinity.com/blog/clickhouse-materialized-views-illuminated-part-1 https://www.altinity.com/blog/clickhouse-materialized-views-... + ClickHouse docs for an intro.
As the parent says, try it yourself on your own data. That's all that counts.
Disclaimer: I wrote the blog article and we sell support for ClickHouse.