Guest User

Untitled

a guest
Jan 21st, 2018
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.12 KB | None | 0 0
  1. Old:
  2.  
  3. Running: float_parsing
  4. [
  5. {
  6. "hostname": "",
  7. "main_metric": "avg_rows_per_second",
  8. "num_cores": 16,
  9. "num_threads": 32,
  10. "parameters": {
  11. "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)))"]
  12. },
  13. "ram": 135171047424,
  14. "runs": [
  15. {
  16. "avg_rows_per_second": 3545665.882266,
  17. "parameters": {
  18. "expr": "toString(1 / rand())"
  19. },
  20. "query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(toString(1 / rand())))"
  21. },
  22. {
  23. "avg_rows_per_second": 4461880.834620,
  24. "parameters": {
  25. "expr": "toString(rand() / 0xFFFFFFFF)"
  26. },
  27. "query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(toString(rand() / 0xFFFFFFFF)))"
  28. },
  29. {
  30. "avg_rows_per_second": 4198941.488236,
  31. "parameters": {
  32. "expr": "toString(0xFFFFFFFF / rand())"
  33. },
  34. "query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(toString(0xFFFFFFFF / rand())))"
  35. },
  36. {
  37. "avg_rows_per_second": 20439724.355637,
  38. "parameters": {
  39. "expr": "toString(number)"
  40. },
  41. "query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(toString(number)))"
  42. },
  43. {
  44. "avg_rows_per_second": 69587139.630213,
  45. "parameters": {
  46. "expr": "toString(number % 10)"
  47. },
  48. "query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(toString(number % 10)))"
  49. },
  50. {
  51. "avg_rows_per_second": 17229754.119245,
  52. "parameters": {
  53. "expr": "toString(rand())"
  54. },
  55. "query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(toString(rand())))"
  56. },
  57. {
  58. "avg_rows_per_second": 8421593.468366,
  59. "parameters": {
  60. "expr": "toString(rand64())"
  61. },
  62. "query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(toString(rand64())))"
  63. },
  64. {
  65. "avg_rows_per_second": 5889418.240498,
  66. "parameters": {
  67. "expr": "concat(toString(rand(1)), '.', toString(rand(2)))"
  68. },
  69. "query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(concat(toString(rand(1)), '.', toString(rand(2)))))"
  70. },
  71. {
  72. "avg_rows_per_second": 5997810.925239,
  73. "parameters": {
  74. "expr": "concat(toString(rand(1)), 'e', toString(rand(2) % 100))"
  75. },
  76. "query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(concat(toString(rand(1)), 'e', toString(rand(2) % 100))))"
  77. },
  78. {
  79. "avg_rows_per_second": 2432228.837560,
  80. "parameters": {
  81. "expr": "concat(toString(rand64(1)), toString(rand64(2)), toString(rand64(3)))"
  82. },
  83. "query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(concat(toString(rand64(1)), toString(rand64(2)), toString(rand64(3)))))"
  84. }
  85. ],
  86. "server_version": "1.1.54318",
  87. "test_name": "float_parsing",
  88. "time": "2018-01-12 04:24:16"
  89. }
  90. ]
  91.  
  92.  
  93. New:
  94.  
  95. Running: float_parsing
  96. [
  97. {
  98. "hostname": "",
  99. "main_metric": "avg_rows_per_second",
  100. "num_cores": 16,
  101. "num_threads": 32,
  102. "parameters": {
  103. "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)))"]
  104. },
  105. "ram": 135171047424,
  106. "runs": [
  107. {
  108. "avg_rows_per_second": 3318331.252098,
  109. "parameters": {
  110. "expr": "toString(1 / rand())"
  111. },
  112. "query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(toString(1 / rand())))"
  113. },
  114. {
  115. "avg_rows_per_second": 3788239.971049,
  116. "parameters": {
  117. "expr": "toString(rand() / 0xFFFFFFFF)"
  118. },
  119. "query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(toString(rand() / 0xFFFFFFFF)))"
  120. },
  121. {
  122. "avg_rows_per_second": 3448818.498863,
  123. "parameters": {
  124. "expr": "toString(0xFFFFFFFF / rand())"
  125. },
  126. "query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(toString(0xFFFFFFFF / rand())))"
  127. },
  128. {
  129. "avg_rows_per_second": 12705281.168645,
  130. "parameters": {
  131. "expr": "toString(number)"
  132. },
  133. "query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(toString(number)))"
  134. },
  135. {
  136. "avg_rows_per_second": 25088191.818842,
  137. "parameters": {
  138. "expr": "toString(number % 10)"
  139. },
  140. "query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(toString(number % 10)))"
  141. },
  142. {
  143. "avg_rows_per_second": 10730279.300147,
  144. "parameters": {
  145. "expr": "toString(rand())"
  146. },
  147. "query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(toString(rand())))"
  148. },
  149. {
  150. "avg_rows_per_second": 4997494.976284,
  151. "parameters": {
  152. "expr": "toString(rand64())"
  153. },
  154. "query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(toString(rand64())))"
  155. },
  156. {
  157. "avg_rows_per_second": 4137515.137013,
  158. "parameters": {
  159. "expr": "concat(toString(rand(1)), '.', toString(rand(2)))"
  160. },
  161. "query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(concat(toString(rand(1)), '.', toString(rand(2)))))"
  162. },
  163. {
  164. "avg_rows_per_second": 5027036.796529,
  165. "parameters": {
  166. "expr": "concat(toString(rand(1)), 'e', toString(rand(2) % 100))"
  167. },
  168. "query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(concat(toString(rand(1)), 'e', toString(rand(2) % 100))))"
  169. },
  170. {
  171. "avg_rows_per_second": 2399234.525139,
  172. "parameters": {
  173. "expr": "concat(toString(rand64(1)), toString(rand64(2)), toString(rand64(3)))"
  174. },
  175. "query": "SELECT count() FROM system.numbers WHERE NOT ignore(toFloat64(concat(toString(rand64(1)), toString(rand64(2)), toString(rand64(3)))))"
  176. }
  177. ],
  178. "server_version": "1.1.54332",
  179. "test_name": "float_parsing",
  180. "time": "2018-01-12 04:28:58"
  181. }
  182. ]
Add Comment
Please, Sign In to add comment