Performance comparison with ClickHouse

[alexey-milovidov]

How does it favor compared to ClickHouse?

[dgllghr]

My plan was to benchmark against chDB and not Clickhouse because chDB is embedded like sqlite+stanchion. However, you are the Clickhouse expert, so maybe I can pick your brain a bit. Is there an existing benchmark suite that you use across chDB and Clickhouse? And since Clickhouse runs as a server, do you have recommendations for setting up a single node Clickhouse server so that it can be compared to an embedded DB?

[alexey-milovidov]

Here is the benchmark suite: https://github.com/ClickHouse/ClickBench

Setting up ClickHouse on a single machine:

curl https://clickhouse.com/ | sh
sudo ./clickhouse install
sudo clickhouse start

Running it in an embedded mode without a server:

curl https://clickhouse.com/ | sh
./clickhouse