Skip to content

Instantly share code, notes, and snippets.

@patoui

patoui/clickhouse_client_comparisons.txt

Created June 12, 2023 12:11
Show Gist options
  • Save patoui/67dec62b050499bb7830333ac21f38a8 to your computer and use it in GitHub Desktop.
Save patoui/67dec62b050499bb7830333ac21f38a8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
clickhouse_client_comparisons.txt
##### dataCount: 10000, seletCount: 1, limit: 5000 #####
PhpClickhouse 0.076
SeasClickNonCompression 0.062
SeasClickCompression 0.064
OneCk 0.095
--------------------------------
Total 0.297
##### dataCount: 10000, seletCount: 1, limit: 5000 #####
PhpClickhouse 0.051
SeasClickNonCompression 0.070
SeasClickCompression 0.066
OneCk 0.092
--------------------------------
Total 0.576
##### dataCount: 10000, seletCount: 100, limit: 5000 #####
PhpClickhouse 0.409
SeasClickNonCompression 0.277
SeasClickCompression 0.253
OneCk 0.278
--------------------------------
Total 1.792
##### dataCount: 10000, seletCount: 100, limit: 10000 #####
PhpClickhouse 0.353
SeasClickNonCompression 0.278
SeasClickCompression 0.240
OneCk 0.272
--------------------------------
Total 2.935
##### dataCount: 1000, seletCount: 200, limit: 500 #####
PhpClickhouse 0.470
SeasClickNonCompression 0.344
SeasClickCompression 0.358
OneCk 0.359
--------------------------------
Total 4.467
##### dataCount: 1000, seletCount: 200, limit: 1000 #####
PhpClickhouse 0.474
SeasClickNonCompression 0.385
SeasClickCompression 0.357
OneCk 0.365
--------------------------------
Total 6.049
##### dataCount: 1000, seletCount: 500, limit: 500 #####
PhpClickhouse 1.142
SeasClickNonCompression 0.853
SeasClickCompression 0.827
OneCk 0.794
--------------------------------
Total 9.665
##### dataCount: 1000, seletCount: 500, limit: 1000 #####
PhpClickhouse 1.146
SeasClickNonCompression 0.804
SeasClickCompression 0.799
OneCk 0.797
--------------------------------
Total 13.211
##### dataCount: 1000, seletCount: 800, limit: 500 #####
PhpClickhouse 1.809
SeasClickNonCompression 1.310
SeasClickCompression 1.205
OneCk 1.240
--------------------------------
Total 18.775
##### dataCount: 1000, seletCount: 800, limit: 1000 #####
PhpClickhouse 1.797
SeasClickNonCompression 1.209
SeasClickCompression 1.277
OneCk 1.216
--------------------------------
Total 24.274
@patoui
Copy link
Author

patoui commented Jun 12, 2023

Benchmark details:

  • ClickHouse server version 23.5.1.3174 (official build).
  • PHP 8.2.7
  • AMD Ryzen 5 5500U
  • 24GB RAM DDR4 3200mHz

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