LocustDB vs ClickHouse

When running a simple count query on a database of 1.46 billion taxi rides, LocustDB completed the query in 0.25 seconds, beating out both Clickhouse and KDB+ (both leading analytics services) which came in at 0.89s and 0.84s respectively.
During testing a number of other queries were run, including average, count by 2/3, sparse filter, top N, reducible cardinality, irreducible cardinality, and dictionary encoding. LocustDB came out on top throughout nearly all of these tests.

Using LocustDB is as simple as installing Rust, cloning the repository, pointing it to your database, and pressing go.

ClickHouse supports multi-master asynchronous replication and can be deployed across multiple datacenters. Downtime of a single node or the whole datacenter won't affect the system's availability for both reads and writes.

ClickHouse scales well both vertically and horizontally. ClickHouse is easily adaptable to perform either on cluster with hundreds of nodes, or on a single server or even on a tiny virtual machine.

ClickHouse uses all available hardware to its full potential to process each query as fast as possible. It processes hundreds of millions to more than a billion rows and tens of gigabytes of data per single server per second.