clickhouse-odbc icon indicating copy to clipboard operation
clickhouse-odbc copied to clipboard

How to enable lz4 compression?

Open paullevchuk opened this issue 5 years ago • 2 comments

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?

paullevchuk avatar Feb 25 '20 08:02 paullevchuk

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

traceon avatar Feb 25 '20 09:02 traceon

Any updates?

paullevchuk avatar Nov 11 '21 08:11 paullevchuk