Re:I wrote one of the fastest DataFrame libraries
by hodgesrm on Tuesday March 16, 2021 @02:45PM
(#26481094)
ClickHouse performance is principally due to column storage, compression, and ability to parallelize processing. Arrays can improve performance in some specific cases but are more commonly used to help deal with semi-structured data or perform custom processing on values within groups.
If your data maps cleanly to tables, that's in fact the best case with the easiest options for performance enhancement.
If your data maps cleanly to tables, that's in fact the best case with the easiest options for performance enhancement.