benchmark_result_events_only 5.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200
  1. Orion V1 endpoint: https://143.42.109.82.nip.io/orion/graphql
  2. Orion V2 endpoint: https://143.42.109.35.nip.io/orion/graphql
  3. {
  4. v1Query: 'GetNotifications',
  5. v2Query: 'GetNotifications',
  6. v1Input: { limit: 1000, channelId: '7757', memberId: '798' },
  7. v2Input: { limit: 1000, channelId: '7757', memberId: '798' },
  8. v1Rows: 110,
  9. v2Rows: 110,
  10. v1Results: [
  11. 1106.0513463020325,
  12. 635.3214621543884,
  13. 665.5094952583313,
  14. 594.7931537628174,
  15. 562.6600451469421
  16. ],
  17. v2Results: [
  18. 1904.6169037818909,
  19. 1453.1587672233582,
  20. 1531.671293258667,
  21. 1379.4050331115723,
  22. 1408.2432866096497
  23. ],
  24. v1Avg: 712.8671005249023,
  25. v2Avg: 1535.4190567970277
  26. }
  27. {
  28. v1Query: 'GetNotifications',
  29. v2Query: 'GetNotifications',
  30. v1Input: { limit: 1000, channelId: '7692', memberId: '2962' },
  31. v2Input: { limit: 1000, channelId: '7692', memberId: '2962' },
  32. v1Rows: 38,
  33. v2Rows: 38,
  34. v1Results: [
  35. 390.9999623298645,
  36. 341.74745512008667,
  37. 314.5849962234497,
  38. 284.43431186676025,
  39. 313.59731101989746
  40. ],
  41. v2Results: [
  42. 1470.9821829795837,
  43. 1350.1738820075989,
  44. 1468.8746967315674,
  45. 1523.363648891449,
  46. 1455.382926940918
  47. ],
  48. v1Avg: 329.0728073120117,
  49. v2Avg: 1453.7554675102233
  50. }
  51. {
  52. v1Query: 'GetNftHistory',
  53. v2Query: 'GetNftHistory',
  54. v1Input: { nftId: '5' },
  55. v2Input: { nftId: '5' },
  56. v1Rows: 20,
  57. v2Rows: 20,
  58. v1Results: [
  59. 224.9494423866272,
  60. 175.72976970672607,
  61. 179.2677140235901,
  62. 174.42952299118042,
  63. 187.78701496124268
  64. ],
  65. v2Results: [
  66. 1092.545313835144,
  67. 1077.791911125183,
  68. 1116.974962234497,
  69. 1140.339367866516,
  70. 1093.845244884491
  71. ],
  72. v1Avg: 188.4326928138733,
  73. v2Avg: 1104.2993599891663
  74. }
  75. {
  76. v1Query: 'GetNftHistory',
  77. v2Query: 'GetNftHistory',
  78. v1Input: { nftId: '14' },
  79. v2Input: { nftId: '14' },
  80. v1Rows: 9,
  81. v2Rows: 9,
  82. v1Results: [
  83. 141.68778324127197,
  84. 157.10310316085815,
  85. 161.84043407440186,
  86. 149.2254762649536,
  87. 168.77385425567627
  88. ],
  89. v2Results: [
  90. 1169.3571248054504,
  91. 1089.0723886489868,
  92. 1106.8910360336304,
  93. 1092.0042786598206,
  94. 1179.6475882530212
  95. ],
  96. v1Avg: 155.72613019943236,
  97. v2Avg: 1127.394483280182
  98. }
  99. {
  100. v1Query: 'GetNftHistory',
  101. v2Query: 'GetNftHistory',
  102. v1Input: { nftId: '338' },
  103. v2Input: { nftId: '338' },
  104. v1Rows: 14,
  105. v2Rows: 14,
  106. v1Results: [
  107. 163.89581203460693,
  108. 175.90639400482178,
  109. 163.9634346961975,
  110. 176.35755491256714,
  111. 170.54833889007568
  112. ],
  113. v2Results: [
  114. 1103.8704543113708,
  115. 1152.5445137023926,
  116. 1109.7572317123413,
  117. 1150.9899983406067,
  118. 1109.5024557113647
  119. ],
  120. v1Avg: 170.1343069076538,
  121. v2Avg: 1125.3329307556153
  122. }
  123. {
  124. v1Query: 'GetNftActivities',
  125. v2Query: 'GetNftActivities',
  126. v1Input: { limit: 1000, memberId: '4537' },
  127. v2Input: { limit: 1000, memberId: '4537' },
  128. v1Rows: 446,
  129. v2Rows: 450,
  130. v1Results: [
  131. 2268.2287921905518,
  132. 2035.5242977142334,
  133. 2156.759829044342,
  134. 2010.4331917762756,
  135. 2034.2985792160034
  136. ],
  137. v2Results: [
  138. 4527.932033061981,
  139. 4637.940931797028,
  140. 4728.392993927002,
  141. 4538.484937667847,
  142. 4606.6357679367065
  143. ],
  144. v1Avg: 2101.048937988281,
  145. v2Avg: 4607.877332878113
  146. }
  147. {
  148. v1Query: 'GetNftActivities',
  149. v2Query: 'GetNftActivities',
  150. v1Input: { limit: 1000, memberId: '798' },
  151. v2Input: { limit: 1000, memberId: '798' },
  152. v1Rows: 376,
  153. v2Rows: 380,
  154. v1Results: [
  155. 1839.6556577682495,
  156. 1941.33367395401,
  157. 1860.6781787872314,
  158. 1713.2440829277039,
  159. 1941.1711330413818
  160. ],
  161. v2Results: [
  162. 4371.274667739868,
  163. 4356.305029392242,
  164. 4343.96886920929,
  165. 4397.0060358047485,
  166. 4485.6696701049805
  167. ],
  168. v1Avg: 1859.2165452957154,
  169. v2Avg: 4390.844854450226
  170. }
  171. ========= QUERIES IN 0ms - Infinity RANGE =========
  172. Tested queries in this range: 7
  173. On average, the average improvement in query execution time in Orion v2 vs Orion v1 is: -340.58%
  174. The median of average improvement in query execution time in Orion v2 vs Orion v1 is: -341.77%
  175. On average, the median improvement in query execution time in Orion v2 vs Orion v1 is: -346.05%
  176. The median of median improvement in query execution time in Orion v2 vs Orion v1 is: -366.92%
  177. ========= QUERIES IN 0ms - 100ms RANGE =========
  178. Tested queries in this range: 0
  179. ========= QUERIES IN 101ms - 500ms RANGE =========
  180. Tested queries in this range: 4
  181. On average, the average improvement in query execution time in Orion v2 vs Orion v1 is: -503.30%
  182. The median of average improvement in query execution time in Orion v2 vs Orion v1 is: -523.74%
  183. On average, the median improvement in query execution time in Orion v2 vs Orion v1 is: -508.09%
  184. The median of median improvement in query execution time in Orion v2 vs Orion v1 is: -530.44%
  185. ========= QUERIES IN 501ms - 2000ms RANGE =========
  186. Tested queries in this range: 2
  187. On average, the average improvement in query execution time in Orion v2 vs Orion v1 is: -125.78%
  188. The median of average improvement in query execution time in Orion v2 vs Orion v1 is: -125.78%
  189. On average, the median improvement in query execution time in Orion v2 vs Orion v1 is: -131.83%
  190. The median of median improvement in query execution time in Orion v2 vs Orion v1 is: -131.83%
  191. ========= QUERIES IN 2000ms - Infinity RANGE =========
  192. Tested queries in this range: 1
  193. On average, the average improvement in query execution time in Orion v2 vs Orion v1 is: -119.31%
  194. The median of average improvement in query execution time in Orion v2 vs Orion v1 is: -119.31%
  195. On average, the median improvement in query execution time in Orion v2 vs Orion v1 is: -126.31%
  196. The median of median improvement in query execution time in Orion v2 vs Orion v1 is: -126.31%