benchsb

Benchmarking for the snow and bend TPC-H queries.

Test method

• TPC-H SF100, data is from redshift, and loaded into Databend/Snowflake.
• Each run, suspend the warehouse, and resume it before the query runs, this is to avoid any cache effect.
• Each run time is the server side time.

How to run

Before run, you should prepare the data and config.

Databend

Setup:

python3 ./benchsb.py --database tpch_sf100 --setup --runbend

Run:

python3 ./benchsb.py --database tpch_sf100 --runbend

Snowflake

Setup:

python3 ./benchsb.py --database tpch_sf100 --setup --runsnow

Run:

python3 ./benchsb.py --database tpch_sf100 --runsnow