Skip to content

Instantly share code, notes, and snippets.

@alexey-milovidov

alexey-milovidov/float_parsing_comparison.txt

Created January 12, 2018 01:36
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save alexey-milovidov/9cedb08d637ffc3511fc356ca2727237 to your computer and use it in GitHub Desktop.
Save alexey-milovidov/9cedb08d637ffc3511fc356ca2727237 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
float_parsing_comparison.txt
Old:
Running: float_parsing
[
{
"hostname": "",
"main_metric": "avg_rows_per_second",
"num_cores": 16,
"num_threads": 32,
"parameters": {
"expr": ["toString(1 / rand())", "toString(rand() / 0xFFFFFFFF)", "toString(0xFFFFFFFF / rand())", "toString(number)", "toString(number % 10)", "toString(rand())", "toString(rand64())", "concat(toString(rand(1)), '.', toString(rand(2)))", "concat(toString(rand(1)), 'e', toString(rand(2) % 100))", "concat(toString(rand64(1)), toString(rand64(2)), toString(rand64(3)))"]
},
"ram": 135171047424,
"runs": [
{
"avg_rows_per_second": 3545665.882266,
"parameters": {
"expr": "toString(1 / rand())"
},
"query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(toString(1 / rand())))"
},
{
"avg_rows_per_second": 4461880.834620,
"parameters": {
"expr": "toString(rand() / 0xFFFFFFFF)"
},
"query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(toString(rand() / 0xFFFFFFFF)))"
},
{
"avg_rows_per_second": 4198941.488236,
"parameters": {
"expr": "toString(0xFFFFFFFF / rand())"
},
"query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(toString(0xFFFFFFFF / rand())))"
},
{
"avg_rows_per_second": 20439724.355637,
"parameters": {
"expr": "toString(number)"
},
"query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(toString(number)))"
},
{
"avg_rows_per_second": 69587139.630213,
"parameters": {
"expr": "toString(number % 10)"
},
"query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(toString(number % 10)))"
},
{
"avg_rows_per_second": 17229754.119245,
"parameters": {
"expr": "toString(rand())"
},
"query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(toString(rand())))"
},
{
"avg_rows_per_second": 8421593.468366,
"parameters": {
"expr": "toString(rand64())"
},
"query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(toString(rand64())))"
},
{
"avg_rows_per_second": 5889418.240498,
"parameters": {
"expr": "concat(toString(rand(1)), '.', toString(rand(2)))"
},
"query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(concat(toString(rand(1)), '.', toString(rand(2)))))"
},
{
"avg_rows_per_second": 5997810.925239,
"parameters": {
"expr": "concat(toString(rand(1)), 'e', toString(rand(2) % 100))"
},
"query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(concat(toString(rand(1)), 'e', toString(rand(2) % 100))))"
},
{
"avg_rows_per_second": 2432228.837560,
"parameters": {
"expr": "concat(toString(rand64(1)), toString(rand64(2)), toString(rand64(3)))"
},
"query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(concat(toString(rand64(1)), toString(rand64(2)), toString(rand64(3)))))"
}
],
"server_version": "1.1.54318",
"test_name": "float_parsing",
"time": "2018-01-12 04:24:16"
}
]
New:
Running: float_parsing
[
{
"hostname": "",
"main_metric": "avg_rows_per_second",
"num_cores": 16,
"num_threads": 32,
"parameters": {
"expr": ["toString(1 / rand())", "toString(rand() / 0xFFFFFFFF)", "toString(0xFFFFFFFF / rand())", "toString(number)", "toString(number % 10)", "toString(rand())", "toString(rand64())", "concat(toString(rand(1)), '.', toString(rand(2)))", "concat(toString(rand(1)), 'e', toString(rand(2) % 100))", "concat(toString(rand64(1)), toString(rand64(2)), toString(rand64(3)))"]
},
"ram": 135171047424,
"runs": [
{
"avg_rows_per_second": 3318331.252098,
"parameters": {
"expr": "toString(1 / rand())"
},
"query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(toString(1 / rand())))"
},
{
"avg_rows_per_second": 3788239.971049,
"parameters": {
"expr": "toString(rand() / 0xFFFFFFFF)"
},
"query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(toString(rand() / 0xFFFFFFFF)))"
},
{
"avg_rows_per_second": 3448818.498863,
"parameters": {
"expr": "toString(0xFFFFFFFF / rand())"
},
"query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(toString(0xFFFFFFFF / rand())))"
},
{
"avg_rows_per_second": 12705281.168645,
"parameters": {
"expr": "toString(number)"
},
"query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(toString(number)))"
},
{
"avg_rows_per_second": 25088191.818842,
"parameters": {
"expr": "toString(number % 10)"
},
"query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(toString(number % 10)))"
},
{
"avg_rows_per_second": 10730279.300147,
"parameters": {
"expr": "toString(rand())"
},
"query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(toString(rand())))"
},
{
"avg_rows_per_second": 4997494.976284,
"parameters": {
"expr": "toString(rand64())"
},
"query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(toString(rand64())))"
},
{
"avg_rows_per_second": 4137515.137013,
"parameters": {
"expr": "concat(toString(rand(1)), '.', toString(rand(2)))"
},
"query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(concat(toString(rand(1)), '.', toString(rand(2)))))"
},
{
"avg_rows_per_second": 5027036.796529,
"parameters": {
"expr": "concat(toString(rand(1)), 'e', toString(rand(2) % 100))"
},
"query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(concat(toString(rand(1)), 'e', toString(rand(2) % 100))))"
},
{
"avg_rows_per_second": 2399234.525139,
"parameters": {
"expr": "concat(toString(rand64(1)), toString(rand64(2)), toString(rand64(3)))"
},
"query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(concat(toString(rand64(1)), toString(rand64(2)), toString(rand64(3)))))"
}
],
"server_version": "1.1.54332",
"test_name": "float_parsing",
"time": "2018-01-12 04:28:58"
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment