3 ms·
> MySQL was using 11GB, ClickHouse 500MB That's pretty typical best case size for weblogs and other time ordered data where column data correlate with time val
by hodgesrm 1y ago
> MySQL was using 11GB, ClickHouse 500MB
That's pretty typical best case size for weblogs and other time ordered data where column data correlate with time values. You do have to tweak the schema a bit to get there. (Specifically a "good" sort order, codecs, ZSTD instead of LZ4 compression, etc.)