Benchmark TPCH Overview
We have made a lot of benchmarks, here are some of them.
- Test Dataset : TPCH's
lineitem.tbl - CPU : Intel(R) Xeon(R) CPU E5-2682 v4 @ 2.50GHz 40 core
- Memory : 224GB
- DISK : 2TB SSD
| Original Data Size | Record Size | TerarkDB Compressed Size | RocksDB Compressed Size |
|---|---|---|---|
| 40 GB | 128 bytes | 8.1 GB | 19 GB |
| 104 GB | 512 bytes | 12 GB | 40 GB |
| 415 GB | 512 bytes | 34 GB | 170 GB |
| 128 GB | 2048 bytes | 4.4 GB | 35 GB |
- Read Only
- About 2,000,000/seconds
- Read Write Mixed
- Reading keeps a pretty high performance, from 600,000/s to 1,200,000/s.
- Writing keeps around 100,000/seconds
| Read Latency | Read Write Mixed | Read (No Background Compression) |
Read (With Background Compression) |
|---|---|---|---|
| < 100ms | 100% | 99.99% | 100% |
| < 15ms | 99.99% | 99.99% | 100% |
| < 5ms | 99.98% | 99.99% | 100% |
| < 2ms | 99.94% | 99.99% | 100% |
| < 0.5ms | 94.70% | 99.99% | 99.99% |