search

ClickHouse / clickhouse-odbc

ODBC driver for ClickHouse
https://clickhouse.tech
Apache License 2.0
245 stars 86 forks source link

How to enable lz4 compression? #268

Open paullevchuk opened 4 years ago

paullevchuk commented 4 years ago

ODBC driver is an order of magnitude slower than a python driver.

When I tested python driver on a table with 1M rows with and without lz4 compression I got the following results: -- with lz4 compression: table downloaded from a server into localhost memory by 9s -- without lz4 compression: table downloaded from a server into localhost memory by 60s.

So my question is how to enable lz4 for ODBC driver?

traceon commented 4 years ago

ODBC driver does not support compression at the moment.

Related issues: https://github.com/ClickHouse/clickhouse-odbc/issues/242 https://github.com/ClickHouse/clickhouse-odbc/issues/220 https://github.com/ClickHouse/clickhouse-odbc/issues/103 https://github.com/ClickHouse/clickhouse-odbc/issues/81

paullevchuk commented 2 years ago

Any updates?