Skip to content

Instantly share code, notes, and snippets.

@Mytherin

Mytherin/Julia TPC-H Benchmarks v0.1

Last active July 22, 2022 11:30
Show Gist options
  • Save Mytherin/e763cd7e2adb364e7f4f781833e0899a to your computer and use it in GitHub Desktop.
Save Mytherin/e763cd7e2adb364e7f4f781833e0899a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Julia TPC-H Benchmarks v0.1
| Queries | DuckDB.jl (1T) | DF Scan (1T) | DuckDB.jl (8T) | DF Scan (8T) | Native (8T) |
|---------|----------------|--------------|----------------|--------------|-------------|
| Q01 | 2.45s | 3.34s | 0.35s | 0.46s | 0.34s |
| Q02 | 0.22s | 0.70s | 0.40s | 0.89s | 0.07s |
| Q03 | 1.07s | 1.36s | 1.17s | 1.66s | 0.27s |
| Q04 | 1.32s | 1.17s | 0.99s | 0.94s | 0.57s |
| Q05 | 1.04s | 1.72s | 1.18s | 1.78s | 0.22s |
| Q06 | 0.47s | 0.50s | 0.07s | 0.08s | 0.07s |
| Q07 | 1.73s | 2.89s | 1.79s | 4.38s | 0.47s |
| Q08 | 1.40s | 1.95s | 1.44s | 2.04s | 0.30s |
| Q09 | 23.8s | 12.2s | 12.9s | 11.5s | 3.44s |
| Q10 | 1.37s | 1.65s | 0.79s | 1.84s | 0.35s |
| Q11 | 0.10s | 0.22s | 0.12s | 0.24s | 0.04s |
| Q12 | 1.67s | 1.96s | 1.70s | 2.07s | 0.42s |
| Q13 | 1.40s | 1.65s | 1.58s | 2.20s | 0.33s |
| Q14 | 0.49s | 0.58s | 0.53s | 0.56s | 0.08s |
| Q15 | 0.75s | 1.03s | 0.33s | 0.18s | 0.35s |
| Q16 | 0.31s | 0.38s | 0.29s | 0.35s | 0.27s |
| Q17 | 2.02s | 2.47s | 2.81s | 1.34s | 0.64s |
| Q18 | 4.22s | 6.53s | 2.71s | 10.24s | 0.98s |
| Q19 | 1.89s | 2.68s | 1.12s | 2.77s | 0.27s |
| Q20 | 1.05s | 1.33s | 0.77s | 2.58s | 0.45s |
| Q21 | 4.65s | 4.49s | 4.21s | 5.36s | 1.21s |
| Q22 | 0.31s | 0.37s | 0.22s | 0.39s | 0.18s |
@Mytherin
Copy link
Author

Mytherin commented Jul 13, 2022 •
edited
Loading

Queries DuckDB.jl (1T) DF Scan (1T) DuckDB.jl (8T) DF Scan (8T) Native (8T)
Q01 2.45s 3.34s 0.35s 0.46s 0.34s
Q02 0.22s 0.70s 0.40s 0.89s 0.07s
Q03 1.07s 1.36s 1.17s 1.66s 0.27s
Q04 1.32s 1.17s 0.99s 0.94s 0.57s
Q05 1.04s 1.72s 1.18s 1.78s 0.22s
Q06 0.47s 0.50s 0.07s 0.08s 0.07s
Q07 1.73s 2.89s 1.79s 4.38s 0.47s
Q08 1.40s 1.95s 1.44s 2.04s 0.30s
Q09 23.8s 12.2s 12.9s 11.5s 3.44s
Q10 1.37s 1.65s 0.79s 1.84s 0.35s
Q11 0.10s 0.22s 0.12s 0.24s 0.04s
Q12 1.67s 1.96s 1.70s 2.07s 0.42s
Q13 1.40s 1.65s 1.58s 2.20s 0.33s
Q14 0.49s 0.58s 0.53s 0.56s 0.08s
Q15 0.75s 1.03s 0.33s 0.18s 0.35s
Q16 0.31s 0.38s 0.29s 0.35s 0.27s
Q17 2.02s 2.47s 2.81s 1.34s 0.64s
Q18 4.22s 6.53s 2.71s 10.24s 0.98s
Q19 1.89s 2.68s 1.12s 2.77s 0.27s
Q20 1.05s 1.33s 0.77s 2.58s 0.45s
Q21 4.65s 4.49s 4.21s 5.36s 1.21s
Q22 0.31s 0.37s 0.22s 0.39s 0.18s
Sum 52.1 49.9 35.6 51.9 10.2

@Mytherin
Copy link
Author

Mytherin commented Jul 21, 2022 •
edited
Loading

New numbers (SF10):

Queries DuckDB.jl (1T) DF Scan (1T) DuckDB.jl (8T) DF Scan (8T) Native (8T)
Q01 2.41s 3.35s 0.33s 0.44s 0.34s
Q02 0.22s 0.70s 0.08s 0.51s 0.07s
Q03 1.09s 1.64s 0.24s 0.52s 0.27s
Q04 1.43s 1.24s 1.00s 0.94s 0.57s
Q05 1.01s 1.75s 0.22s 0.64s 0.22s
Q06 0.46s 0.51s 0.09s 0.08s 0.07s
Q07 1.73s 3.07s 0.57s 1.77s 0.47s
Q08 1.38s 1.90s 0.22s 0.47s 0.30s
Q09 22.78s 12.02s 3.40s 9.50s 3.44s
Q10 1.41s 1.96s 0.34s 0.66s 0.35s
Q11 0.10s 0.26s 0.05s 0.06s 0.04s
Q12 1.66s 2.03s 0.59s 2.70s 0.42s
Q13 1.45s 1.70s 0.29s 0.44s 0.33s
Q14 0.49s 0.60s 0.09s 0.10s 0.08s
Q15 0.79s 1.04s 0.30s 0.18s 0.35s
Q16 0.29s 0.36s 0.38s 0.39s 0.27s
Q17 2.04s 2.54s 0.58s 0.64s 0.64s
Q18 3.76s 6.49s 0.85s 1.95s 0.98s
Q19 1.91s 2.72s 0.32s 0.43s 0.27s
Q20 1.06s 1.39s 0.53s 0.69s 0.45s
Q21 4.37s 6.26s 1.87s 2.26s 1.21s
Q22 0.31s 0.37s 0.25s 0.27s 0.18s
Sum 51.1s 53.0 11.5 24.6 10.2

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment