Re:We 5x'ed Our SQL Query Performance with ClickHouse
by underanalyzer on Sunday January 08, 2023 @12:25AM
(#34296328)
Neat post! I'd be curious to see some simple examples of each what the slow queries looked like. It seems to my limited knowledge they attempted to use row based dbs / mongo for column based workloads then saw a large perf boost after switching to Clickhouse.
[ Parent
| on HN ]
Re:We 5x'ed Our SQL Query Performance with ClickHouse
by ardabulut on Tuesday January 10, 2023 @06:18PM
(#34332878)
That's exactly right! As I explained in the post, we made a big tradeoff to get things started at the beginning, which was using mongo to handle large analytics workloads. It's been a year since I wrote this post but we've had a lot of success improving query performance within ClickHouse as well. Will write about that soon :)