Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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"
- }
- ]
Add Comment
Please, Sign In to add comment