benchmark_result 39 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748
  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: 'GetBids',
  5. v2Query: 'GetBids',
  6. v1Input: { where: { nft: [Object] } },
  7. v2Input: { where: { auction: [Object] } },
  8. v1Rows: 11,
  9. v2Rows: 11,
  10. v1Results: [
  11. 451.6073489189148,
  12. 114.20155811309814,
  13. 106.01173877716064,
  14. 101.04585790634155,
  15. 128.7146201133728
  16. ],
  17. v2Results: [
  18. 267.9239549636841,
  19. 65.42646789550781,
  20. 67.24522495269775,
  21. 66.71128702163696,
  22. 65.09114170074463
  23. ],
  24. v1Avg: 180.31622476577758,
  25. v2Avg: 106.47961530685424
  26. }
  27. {
  28. v1Query: 'GetBids',
  29. v2Query: 'GetBids',
  30. v1Input: { where: { bidder: [Object] } },
  31. v2Input: { where: { bidder: [Object] } },
  32. v1Rows: 5,
  33. v2Rows: 5,
  34. v1Results: [
  35. 90.37601375579834,
  36. 91.17880010604858,
  37. 90.95580768585205,
  38. 88.20493507385254,
  39. 88.19603109359741
  40. ],
  41. v2Results: [
  42. 61.92208242416382,
  43. 60.4068169593811,
  44. 65.43991899490356,
  45. 68.17588806152344,
  46. 59.92394304275513
  47. ],
  48. v1Avg: 89.78231754302979,
  49. v2Avg: 63.17372989654541
  50. }
  51. {
  52. v1Query: 'GetBids',
  53. v2Query: 'GetBids',
  54. v1Input: { where: {}, limit: 100 },
  55. v2Input: { where: {}, limit: 100 },
  56. v1Rows: 54,
  57. v2Rows: 54,
  58. v1Results: [
  59. 304.3629755973816,
  60. 267.896635055542,
  61. 325.00013971328735,
  62. 275.5339198112488,
  63. 245.78830814361572
  64. ],
  65. v2Results: [
  66. 134.60595512390137,
  67. 121.77902936935425,
  68. 119.463134765625,
  69. 122.28263092041016,
  70. 114.59080600738525
  71. ],
  72. v1Avg: 283.7163956642151,
  73. v2Avg: 122.54431123733521
  74. }
  75. {
  76. v1Query: 'GetVideoCategories',
  77. v2Query: 'GetExtendedVideoCategories',
  78. v1Input: undefined,
  79. v2Input: undefined,
  80. v1Rows: 29,
  81. v2Rows: 29,
  82. v1Results: [
  83. 67.63761901855469,
  84. 61.41241502761841,
  85. 54.07106685638428,
  86. 59.953453063964844,
  87. 62.78451585769653
  88. ],
  89. v2Results: [
  90. 72.4404411315918,
  91. 55.936996936798096,
  92. 56.505009174346924,
  93. 60.57462978363037,
  94. 57.27991962432861
  95. ],
  96. v1Avg: 61.17181396484375,
  97. v2Avg: 60.54739933013916
  98. }
  99. {
  100. v1Query: 'GetFullChannel',
  101. v2Query: 'GetFullChannel',
  102. v1Input: { where: { id: '7757' } },
  103. v2Input: { id: '7757' },
  104. v1Rows: 1,
  105. v2Rows: 1,
  106. v1Results: [
  107. 73.93110370635986,
  108. 69.3416428565979,
  109. 69.40294122695923,
  110. 62.49119806289673,
  111. 72.97301626205444
  112. ],
  113. v2Results: [
  114. 66.32205009460449,
  115. 57.584778785705566,
  116. 57.90076971054077,
  117. 64.42083501815796,
  118. 56.27457571029663
  119. ],
  120. v1Avg: 69.62798042297364,
  121. v2Avg: 60.500601863861085
  122. }
  123. {
  124. v1Query: 'GetVideoCount',
  125. v2Query: 'GetVideoCount',
  126. v1Input: { where: { category: [Object] } },
  127. v2Input: { where: { category: [Object] } },
  128. v1Rows: 1,
  129. v2Rows: 1,
  130. v1Results: [
  131. 72.92594003677368,
  132. 63.20552062988281,
  133. 66.65710020065308,
  134. 68.4023380279541,
  135. 65.44714260101318
  136. ],
  137. v2Results: [
  138. 60.32369327545166,
  139. 62.29304313659668,
  140. 61.23977184295654,
  141. 59.735437870025635,
  142. 59.11085319519043
  143. ],
  144. v1Avg: 67.32760829925537,
  145. v2Avg: 60.54055986404419
  146. }
  147. {
  148. v1Query: 'GetVideoCount',
  149. v2Query: 'GetVideoCount',
  150. v1Input: { where: {} },
  151. v2Input: { where: {} },
  152. v1Rows: 1,
  153. v2Rows: 1,
  154. v1Results: [
  155. 62.79400587081909,
  156. 64.649827003479,
  157. 62.23615264892578,
  158. 59.6593599319458,
  159. 58.77700901031494
  160. ],
  161. v2Results: [
  162. 56.736756324768066,
  163. 57.29971218109131,
  164. 52.639094829559326,
  165. 54.709716796875,
  166. 52.31397294998169
  167. ],
  168. v1Avg: 61.62327089309692,
  169. v2Avg: 54.73985061645508
  170. }
  171. {
  172. v1Query: 'GetBasicChannels',
  173. v2Query: 'GetExtendedBasicChannels',
  174. v1Input: {
  175. where: { activeVideosCounter_gt: 1, language: [Object] },
  176. limit: 100,
  177. orderBy: 'createdAt_ASC'
  178. },
  179. v2Input: {
  180. where: { activeVideosCount_gt: 1, channel: [Object] },
  181. limit: 100,
  182. orderBy: 'createdAt_ASC'
  183. },
  184. v1Rows: 45,
  185. v2Rows: 45,
  186. v1Results: [
  187. 178.79056692123413,
  188. 129.10826683044434,
  189. 143.36266708374023,
  190. 130.6205611228943,
  191. 151.6289529800415
  192. ],
  193. v2Results: [
  194. 130.6102843284607,
  195. 87.16336584091187,
  196. 71.93801021575928,
  197. 66.26082801818848,
  198. 67.75594902038574
  199. ],
  200. v1Avg: 146.7022029876709,
  201. v2Avg: 84.74568748474121
  202. }
  203. {
  204. v1Query: 'GetBasicChannels',
  205. v2Query: 'GetExtendedBasicChannels',
  206. v1Input: { where: {}, limit: 100 },
  207. v2Input: { where: {}, limit: 100 },
  208. v1Rows: 100,
  209. v2Rows: 100,
  210. v1Results: [
  211. 173.36541604995728,
  212. 220.23044109344482,
  213. 200.27008485794067,
  214. 200.69436693191528,
  215. 192.70560503005981
  216. ],
  217. v2Results: [
  218. 167.95117855072021,
  219. 162.95448207855225,
  220. 165.16422700881958,
  221. 165.57441997528076,
  222. 167.28913974761963
  223. ],
  224. v1Avg: 197.45318279266357,
  225. v2Avg: 165.78668947219847
  226. }
  227. {
  228. v1Query: 'GetBasicChannels',
  229. v2Query: 'GetExtendedBasicChannels',
  230. v1Input: { where: {}, limit: 1000 },
  231. v2Input: { where: {}, limit: 1000 },
  232. v1Rows: 1000,
  233. v2Rows: 1000,
  234. v1Results: [
  235. 1205.7221760749817,
  236. 1200.7246718406677,
  237. 1152.6847352981567,
  238. 1045.1255683898926,
  239. 1043.264066696167
  240. ],
  241. v2Results: [
  242. 403.0171160697937,
  243. 365.16763973236084,
  244. 360.86713886260986,
  245. 356.7894597053528,
  246. 638.9542942047119
  247. ],
  248. v1Avg: 1129.504243659973,
  249. v2Avg: 424.9591297149658
  250. }
  251. {
  252. v1Query: 'GetFullChannels',
  253. v2Query: 'GetExtendedFullChannels',
  254. v1Input: { where: { activeVideosCounter_gt: 5 } },
  255. v2Input: { where: { activeVideosCount_gt: 5 } },
  256. v1Rows: 17,
  257. v2Rows: 17,
  258. v1Results: [
  259. 193.95196914672852,
  260. 190.84022617340088,
  261. 180.09491729736328,
  262. 187.3145251274109,
  263. 209.67547798156738
  264. ],
  265. v2Results: [
  266. 175.58866691589355,
  267. 163.25306224822998,
  268. 166.52650213241577,
  269. 160.48963594436646,
  270. 168.3750901222229
  271. ],
  272. v1Avg: 192.37542314529418,
  273. v2Avg: 166.84659147262573
  274. }
  275. {
  276. v1Query: 'GetFullChannels',
  277. v2Query: 'GetExtendedFullChannels',
  278. v1Input: { where: {}, limit: 100 },
  279. v2Input: { where: {}, limit: 100 },
  280. v1Rows: 100,
  281. v2Rows: 100,
  282. v1Results: [
  283. 491.4386773109436,
  284. 490.5867381095886,
  285. 493.37763500213623,
  286. 476.0246319770813,
  287. 519.8726239204407
  288. ],
  289. v2Results: [
  290. 291.05618715286255,
  291. 296.22258853912354,
  292. 292.77316665649414,
  293. 328.04914903640747,
  294. 284.609356880188
  295. ],
  296. v1Avg: 494.2600612640381,
  297. v2Avg: 298.5420896530151
  298. }
  299. {
  300. v1Query: 'GetFullChannels',
  301. v2Query: 'GetExtendedFullChannels',
  302. v1Input: { where: {}, limit: 1000 },
  303. v2Input: { where: {}, limit: 1000 },
  304. v1Rows: 1000,
  305. v2Rows: 1000,
  306. v1Results: [
  307. 3886.396867275238,
  308. 3593.615144252777,
  309. 3714.1051630973816,
  310. 3899.643774032593,
  311. 3710.19717168808
  312. ],
  313. v2Results: [
  314. 893.1546912193298,
  315. 814.763729095459,
  316. 799.289128780365,
  317. 741.7758016586304,
  318. 713.1137599945068
  319. ],
  320. v1Avg: 3760.791624069214,
  321. v2Avg: 792.4194221496582
  322. }
  323. {
  324. v1Query: 'GetBasicChannelsConnection',
  325. v2Query: 'GetBasicChannelsConnection',
  326. v1Input: {
  327. where: { title_contains: 'a', avatarPhoto: [Object], isPublic_eq: true },
  328. first: 50
  329. },
  330. v2Input: {
  331. where: { title_contains: 'a', avatarPhoto: [Object], isPublic_eq: true },
  332. first: 50
  333. },
  334. v1Rows: 50,
  335. v2Rows: 50,
  336. v1Results: [
  337. 235.89207696914673,
  338. 164.3727011680603,
  339. 166.9079098701477,
  340. 174.40144300460815,
  341. 169.3932490348816
  342. ],
  343. v2Results: [
  344. 83.52474021911621,
  345. 79.34227991104126,
  346. 74.15279388427734,
  347. 80.53447961807251,
  348. 78.60183095932007
  349. ],
  350. v1Avg: 182.1934760093689,
  351. v2Avg: 79.23122491836548
  352. }
  353. {
  354. v1Query: 'GetTop10Channels',
  355. v2Query: 'GetTop10Channels',
  356. v1Input: { where: { activeVideosCounter_gt: 0, isPublic_eq: true } },
  357. v2Input: { where: { activeVideosCount_gt: 0, channel: [Object] } },
  358. v1Rows: 0,
  359. v2Rows: 0,
  360. v1Results: [
  361. 55.634692668914795,
  362. 54.121520042419434,
  363. 52.466662883758545,
  364. 61.26058912277222,
  365. 56.689069747924805
  366. ],
  367. v2Results: [
  368. 64.95254182815552,
  369. 56.5157036781311,
  370. 60.15813493728638,
  371. 56.09858322143555,
  372. 61.32310104370117
  373. ],
  374. v1Avg: 56.03450689315796,
  375. v2Avg: 59.809612941741946
  376. }
  377. {
  378. v1Query: 'GetPromisingChannels',
  379. v2Query: 'GetPromisingChannels',
  380. v1Input: { where: { activeVideosCounter_gt: 4, isPublic_eq: true } },
  381. v2Input: { where: { activeVideosCount_gt: 4, channel: [Object] } },
  382. v1Rows: 0,
  383. v2Rows: 0,
  384. v1Results: [
  385. 118.96855068206787,
  386. 128.19401502609253,
  387. 111.16012573242188,
  388. 106.00648307800293,
  389. 102.57280778884888
  390. ],
  391. v2Results: [
  392. 69.84083414077759,
  393. 64.38641691207886,
  394. 67.94728088378906,
  395. 64.48251104354858,
  396. 62.70247793197632
  397. ],
  398. v1Avg: 113.38039646148681,
  399. v2Avg: 65.87190418243408
  400. }
  401. {
  402. v1Query: 'GetDiscoverChannels',
  403. v2Query: 'GetDiscoverChannels',
  404. v1Input: { where: { activeVideosCounter_gt: 4, isPublic_eq: true } },
  405. v2Input: { where: { activeVideosCount_gt: 4, channel: [Object] } },
  406. v1Rows: 0,
  407. v2Rows: 0,
  408. v1Results: [
  409. 106.04616832733154,
  410. 112.5551381111145,
  411. 109.14944505691528,
  412. 120.06705236434937,
  413. 109.43275499343872
  414. ],
  415. v2Results: [
  416. 61.66274881362915,
  417. 57.57513618469238,
  418. 61.72244691848755,
  419. 58.907649993896484,
  420. 62.95890998840332
  421. ],
  422. v1Avg: 111.45011177062989,
  423. v2Avg: 60.56537837982178
  424. }
  425. {
  426. v1Query: 'GetPopularChannels',
  427. v2Query: 'GetPopularChannels',
  428. v1Input: { where: { activeVideosCounter_gt: 4, isPublic_eq: true } },
  429. v2Input: { where: { activeVideosCount_gt: 4, channel: [Object] } },
  430. v1Rows: 0,
  431. v2Rows: 0,
  432. v1Results: [
  433. 56.282920360565186,
  434. 53.66085910797119,
  435. 60.297786235809326,
  436. 57.574613094329834,
  437. 59.22861289978027
  438. ],
  439. v2Results: [
  440. 61.76993942260742,
  441. 63.31771183013916,
  442. 59.37308979034424,
  443. 68.91024017333984,
  444. 59.89177227020264
  445. ],
  446. v1Avg: 57.40895833969116,
  447. v2Avg: 62.65255069732666
  448. }
  449. {
  450. v1Query: 'GetChannelNftCollectors',
  451. v2Query: 'GetChannelNftCollectors',
  452. v1Input: { where: { channel: [Object] } },
  453. v2Input: { channelId: '7693' },
  454. v1Rows: 8,
  455. v2Rows: 8,
  456. v1Results: [
  457. 75.03145980834961,
  458. 79.18820333480835,
  459. 67.39400386810303,
  460. 74.03173971176147,
  461. 72.80786323547363
  462. ],
  463. v2Results: [
  464. 67.48623991012573,
  465. 59.69623422622681,
  466. 59.331666469573975,
  467. 59.56627178192139,
  468. 58.40815734863281
  469. ],
  470. v1Avg: 73.69065399169922,
  471. v2Avg: 60.89771394729614
  472. }
  473. {
  474. v1Query: 'GetComment',
  475. v2Query: 'GetComment',
  476. v1Input: { commentId: 'METAPROTOCOL-OLYMPIA-769463-2' },
  477. v2Input: { commentId: 'METAPROTOCOL-OLYMPIA-769463-2' },
  478. v1Rows: 1,
  479. v2Rows: 1,
  480. v1Results: [
  481. 63.760324001312256,
  482. 58.47451686859131,
  483. 58.608006954193115,
  484. 58.659850120544434,
  485. 58.421006202697754
  486. ],
  487. v2Results: [
  488. 60.79394340515137,
  489. 54.84171676635742,
  490. 59.06128215789795,
  491. 54.15728282928467,
  492. 57.00504970550537
  493. ],
  494. v1Avg: 59.584740829467776,
  495. v2Avg: 57.171854972839355
  496. }
  497. {
  498. v1Query: 'GetCommentRepliesConnection',
  499. v2Query: 'GetCommentRepliesConnection',
  500. v1Input: {
  501. parentCommentId: 'METAPROTOCOL-OLYMPIA-874662-2',
  502. first: 10,
  503. orderBy: 'createdAt_DESC'
  504. },
  505. v2Input: {
  506. parentCommentId: 'METAPROTOCOL-OLYMPIA-874662-2',
  507. first: 10,
  508. orderBy: 'createdAt_DESC'
  509. },
  510. v1Rows: 2,
  511. v2Rows: 2,
  512. v1Results: [
  513. 68.1422791481018,
  514. 66.33758211135864,
  515. 67.44891738891602,
  516. 64.9177827835083,
  517. 66.80030918121338
  518. ],
  519. v2Results: [
  520. 60.83445596694946,
  521. 58.08392095565796,
  522. 55.81062602996826,
  523. 58.84915828704834,
  524. 62.00218486785889
  525. ],
  526. v1Avg: 66.72937412261963,
  527. v2Avg: 59.11606922149658
  528. }
  529. {
  530. v1Query: 'GetUserCommentsAndVideoCommentsConnection',
  531. v2Query: 'GetUserCommentsAndVideoCommentsConnection',
  532. v1Input: {
  533. videoId: '5',
  534. memberId: '4680',
  535. first: 10,
  536. orderBy: 'createdAt_DESC'
  537. },
  538. v2Input: {
  539. videoId: '5',
  540. memberId: '4680',
  541. first: 10,
  542. orderBy: 'createdAt_DESC'
  543. },
  544. v1Rows: 11,
  545. v2Rows: 11,
  546. v1Results: [
  547. 101.38298988342285,
  548. 105.04670190811157,
  549. 97.98076105117798,
  550. 100.79863405227661,
  551. 99.02087497711182
  552. ],
  553. v2Results: [
  554. 79.94801616668701,
  555. 68.6978268623352,
  556. 67.52224493026733,
  557. 77.45289468765259,
  558. 73.63604736328125
  559. ],
  560. v1Avg: 100.84599237442016,
  561. v2Avg: 73.45140600204468
  562. }
  563. {
  564. v1Query: 'GetUserCommentsReactions',
  565. v2Query: 'GetUserCommentsReactions',
  566. v1Input: { memberId: '3233', videoId: '193' },
  567. v2Input: { memberId: '3233', videoId: '193' },
  568. v1Rows: 5,
  569. v2Rows: 5,
  570. v1Results: [
  571. 64.82499980926514,
  572. 58.72316884994507,
  573. 56.67060422897339,
  574. 60.69253206253052,
  575. 55.78748369216919
  576. ],
  577. v2Results: [
  578. 61.91022491455078,
  579. 51.87665510177612,
  580. 53.88494396209717,
  581. 54.754793643951416,
  582. 54.111567974090576
  583. ],
  584. v1Avg: 59.33975772857666,
  585. v2Avg: 55.30763711929321
  586. }
  587. {
  588. v1Query: 'GetCommentEdits',
  589. v2Query: 'GetCommentEdits',
  590. v1Input: { commentId: 'METAPROTOCOL-OLYMPIA-1049713-2' },
  591. v2Input: { commentId: 'METAPROTOCOL-OLYMPIA-1049713-2' },
  592. v1Rows: 2,
  593. v2Rows: 2,
  594. v1Results: [
  595. 62.68960905075073,
  596. 57.97328996658325,
  597. 57.086419105529785,
  598. 60.27161121368408,
  599. 62.89357614517212
  600. ],
  601. v2Results: [
  602. 64.36245393753052,
  603. 61.04490089416504,
  604. 58.92174816131592,
  605. 65.44227933883667,
  606. 58.809218883514404
  607. ],
  608. v1Avg: 60.182901096344,
  609. v2Avg: 61.71612024307251
  610. }
  611. {
  612. v1Query: 'GetDataObjectAvailability',
  613. v2Query: 'GetDataObjectAvailability',
  614. v1Input: {
  615. id_in: [
  616. '0', '1', '2', '3',
  617. '4', '5', '6', '7',
  618. '8', '9'
  619. ],
  620. limit: 10
  621. },
  622. v2Input: {
  623. id_in: [
  624. '0', '1', '2', '3',
  625. '4', '5', '6', '7',
  626. '8', '9'
  627. ],
  628. limit: 10
  629. },
  630. v1Rows: 10,
  631. v2Rows: 10,
  632. v1Results: [
  633. 67.98108291625977,
  634. 58.376338958740234,
  635. 61.982563972473145,
  636. 56.46553134918213,
  637. 62.47335386276245
  638. ],
  639. v2Results: [
  640. 53.37629175186157,
  641. 54.1727409362793,
  642. 49.326687812805176,
  643. 49.755455017089844,
  644. 48.75551462173462
  645. ],
  646. v1Avg: 61.45577421188354,
  647. v2Avg: 51.0773380279541
  648. }
  649. {
  650. v1Query: 'GetDataObjectAvailability',
  651. v2Query: 'GetDataObjectAvailability',
  652. v1Input: {
  653. id_in: [
  654. '0', '1', '2', '3', '4', '5', '6', '7', '8', '9',
  655. '10', '11', '12', '13', '14', '15', '16', '17', '18', '19',
  656. '20', '21', '22', '23', '24', '25', '26', '27', '28', '29',
  657. '30', '31', '32', '33', '34', '35', '36', '37', '38', '39',
  658. '40', '41', '42', '43', '44', '45', '46', '47', '48', '49',
  659. '50', '51', '52', '53', '54', '55', '56', '57', '58', '59',
  660. '60', '61', '62', '63', '64', '65', '66', '67', '68', '69',
  661. '70', '71', '72', '73', '74', '75', '76', '77', '78', '79',
  662. '80', '81', '82', '83', '84', '85', '86', '87', '88', '89',
  663. '90', '91', '92', '93', '94', '95', '96', '97', '98', '99'
  664. ],
  665. limit: 100
  666. },
  667. v2Input: {
  668. id_in: [
  669. '0', '1', '2', '3', '4', '5', '6', '7', '8', '9',
  670. '10', '11', '12', '13', '14', '15', '16', '17', '18', '19',
  671. '20', '21', '22', '23', '24', '25', '26', '27', '28', '29',
  672. '30', '31', '32', '33', '34', '35', '36', '37', '38', '39',
  673. '40', '41', '42', '43', '44', '45', '46', '47', '48', '49',
  674. '50', '51', '52', '53', '54', '55', '56', '57', '58', '59',
  675. '60', '61', '62', '63', '64', '65', '66', '67', '68', '69',
  676. '70', '71', '72', '73', '74', '75', '76', '77', '78', '79',
  677. '80', '81', '82', '83', '84', '85', '86', '87', '88', '89',
  678. '90', '91', '92', '93', '94', '95', '96', '97', '98', '99'
  679. ],
  680. limit: 100
  681. },
  682. v1Rows: 99,
  683. v2Rows: 99,
  684. v1Results: [
  685. 74.95590019226074,
  686. 66.29628086090088,
  687. 64.87846326828003,
  688. 72.6738109588623,
  689. 67.58620166778564
  690. ],
  691. v2Results: [
  692. 54.45785093307495,
  693. 56.590288162231445,
  694. 61.86349868774414,
  695. 56.43477010726929,
  696. 58.11848783493042
  697. ],
  698. v1Avg: 69.27813138961793,
  699. v2Avg: 57.49297914505005
  700. }
  701. {
  702. v1Query: 'GetDataObjectAvailability',
  703. v2Query: 'GetDataObjectAvailability',
  704. v1Input: {
  705. id_in: [
  706. '0', '1', '2', '3', '4', '5', '6', '7', '8', '9',
  707. '10', '11', '12', '13', '14', '15', '16', '17', '18', '19',
  708. '20', '21', '22', '23', '24', '25', '26', '27', '28', '29',
  709. '30', '31', '32', '33', '34', '35', '36', '37', '38', '39',
  710. '40', '41', '42', '43', '44', '45', '46', '47', '48', '49',
  711. '50', '51', '52', '53', '54', '55', '56', '57', '58', '59',
  712. '60', '61', '62', '63', '64', '65', '66', '67', '68', '69',
  713. '70', '71', '72', '73', '74', '75', '76', '77', '78', '79',
  714. '80', '81', '82', '83', '84', '85', '86', '87', '88', '89',
  715. '90', '91', '92', '93', '94', '95', '96', '97', '98', '99',
  716. ... 900 more items
  717. ],
  718. limit: 1000
  719. },
  720. v2Input: {
  721. id_in: [
  722. '0', '1', '2', '3', '4', '5', '6', '7', '8', '9',
  723. '10', '11', '12', '13', '14', '15', '16', '17', '18', '19',
  724. '20', '21', '22', '23', '24', '25', '26', '27', '28', '29',
  725. '30', '31', '32', '33', '34', '35', '36', '37', '38', '39',
  726. '40', '41', '42', '43', '44', '45', '46', '47', '48', '49',
  727. '50', '51', '52', '53', '54', '55', '56', '57', '58', '59',
  728. '60', '61', '62', '63', '64', '65', '66', '67', '68', '69',
  729. '70', '71', '72', '73', '74', '75', '76', '77', '78', '79',
  730. '80', '81', '82', '83', '84', '85', '86', '87', '88', '89',
  731. '90', '91', '92', '93', '94', '95', '96', '97', '98', '99',
  732. ... 900 more items
  733. ],
  734. limit: 1000
  735. },
  736. v1Rows: 954,
  737. v2Rows: 954,
  738. v1Results: [
  739. 129.60854387283325,
  740. 123.82021808624268,
  741. 127.32239818572998,
  742. 125.7621431350708,
  743. 134.17256021499634
  744. ],
  745. v2Results: [
  746. 79.85085773468018,
  747. 75.6263780593872,
  748. 69.25914716720581,
  749. 72.1812539100647,
  750. 66.43816804885864
  751. ],
  752. v1Avg: 128.1371726989746,
  753. v2Avg: 72.6711609840393
  754. }
  755. {
  756. v1Query: 'GetAllCategoriesFeaturedVideos',
  757. v2Query: 'GetAllCategoriesFeaturedVideos',
  758. v1Input: undefined,
  759. v2Input: undefined,
  760. v1Rows: 0,
  761. v2Rows: 0,
  762. v1Results: [
  763. 65.91067600250244,
  764. 55.22586107254028,
  765. 64.7338490486145,
  766. 51.20635509490967,
  767. 52.616971015930176
  768. ],
  769. v2Results: [
  770. 93.53805589675903,
  771. 85.31139802932739,
  772. 79.91429805755615,
  773. 79.89435815811157,
  774. 75.81462526321411
  775. ],
  776. v1Avg: 57.93874244689941,
  777. v2Avg: 82.89454708099365
  778. }
  779. {
  780. v1Query: 'GetMemberships',
  781. v2Query: 'GetMemberships',
  782. v1Input: { where: { controllerAccount_in: [Array] } },
  783. v2Input: { where: { controllerAccount_in: [Array] } },
  784. v1Rows: 50,
  785. v2Rows: 50,
  786. v1Results: [
  787. 222.62482357025146,
  788. 169.91324520111084,
  789. 175.36150074005127,
  790. 172.30606508255005,
  791. 181.8167748451233
  792. ],
  793. v2Results: [
  794. 74.62292289733887,
  795. 63.325045585632324,
  796. 65.19469833374023,
  797. 62.48115682601929,
  798. 71.37512540817261
  799. ],
  800. v1Avg: 184.40448188781738,
  801. v2Avg: 67.39978981018066
  802. }
  803. {
  804. v1Query: 'GetMemberships',
  805. v2Query: 'GetMemberships',
  806. v1Input: { where: {}, limit: 100 },
  807. v2Input: { where: {}, limit: 100 },
  808. v1Rows: 100,
  809. v2Rows: 100,
  810. v1Results: [
  811. 319.1039433479309,
  812. 335.1447548866272,
  813. 322.6870470046997,
  814. 308.63164472579956,
  815. 318.19133043289185
  816. ],
  817. v2Results: [
  818. 125.20798921585083,
  819. 159.95756340026855,
  820. 118.78639698028564,
  821. 125.6853699684143,
  822. 121.26108694076538
  823. ],
  824. v1Avg: 320.75174407958986,
  825. v2Avg: 130.17968130111694
  826. }
  827. {
  828. v1Query: 'GetMemberships',
  829. v2Query: 'GetMemberships',
  830. v1Input: { where: {}, limit: 1000 },
  831. v2Input: { where: {}, limit: 1000 },
  832. v1Rows: 1000,
  833. v2Rows: 1000,
  834. v1Results: [
  835. 31561.164360046387,
  836. 30392.431162834167,
  837. 30117.18757200241,
  838. 29851.098025798798,
  839. 30027.455605983734
  840. ],
  841. v2Results: [
  842. 3063.888674736023,
  843. 3229.2635340690613,
  844. 3156.872458934784,
  845. 3092.045279979706,
  846. 3078.773596763611
  847. ],
  848. v1Avg: 30389.8673453331,
  849. v2Avg: 3124.168708896637
  850. }
  851. {
  852. v1Query: 'GetNft',
  853. v2Query: 'GetNft',
  854. v1Input: { id: '5' },
  855. v2Input: { id: '5' },
  856. v1Rows: 1,
  857. v2Rows: 1,
  858. v1Results: [
  859. 91.2691707611084,
  860. 73.79289293289185,
  861. 78.17633581161499,
  862. 76.20761680603027,
  863. 78.76906394958496
  864. ],
  865. v2Results: [
  866. 155.87402486801147,
  867. 101.62593793869019,
  868. 86.68707799911499,
  869. 89.40459394454956,
  870. 95.70322895050049
  871. ],
  872. v1Avg: 79.6430160522461,
  873. v2Avg: 105.85897274017334
  874. }
  875. {
  876. v1Query: 'GetNft',
  877. v2Query: 'GetNft',
  878. v1Input: { id: '9' },
  879. v2Input: { id: '9' },
  880. v1Rows: 1,
  881. v2Rows: 1,
  882. v1Results: [
  883. 84.73744487762451,
  884. 81.08872699737549,
  885. 74.04753971099854,
  886. 71.21485614776611,
  887. 73.30465412139893
  888. ],
  889. v2Results: [
  890. 90.00795698165894,
  891. 89.31843996047974,
  892. 91.29979515075684,
  893. 95.273184299469,
  894. 85.01616191864014
  895. ],
  896. v1Avg: 76.87864437103272,
  897. v2Avg: 90.18310766220092
  898. }
  899. {
  900. v1Query: 'GetNfts',
  901. v2Query: 'GetNfts',
  902. v1Input: { where: {}, limit: 100 },
  903. v2Input: { where: {}, limit: 100 },
  904. v1Rows: 100,
  905. v2Rows: 100,
  906. v1Results: [
  907. 1508.7081952095032,
  908. 1441.308193206787,
  909. 1422.7598690986633,
  910. 1428.6702208518982,
  911. 1402.7967190742493
  912. ],
  913. v2Results: [
  914. 435.9036021232605,
  915. 427.1053080558777,
  916. 399.91761207580566,
  917. 393.53779125213623,
  918. 464.017352104187
  919. ],
  920. v1Avg: 1440.8486394882202,
  921. v2Avg: 424.09633312225344
  922. }
  923. {
  924. v1Query: 'GetNfts',
  925. v2Query: 'GetNfts',
  926. v1Input: { where: {}, limit: 1000 },
  927. v2Input: { where: {}, limit: 1000 },
  928. v1Rows: 658,
  929. v2Rows: 658,
  930. v1Results: [
  931. 9254.795014858246,
  932. 8504.871553897858,
  933. 8642.884343147278,
  934. 8569.958996295929,
  935. 8381.646343231201
  936. ],
  937. v2Results: [
  938. 918.3122339248657,
  939. 935.5347948074341,
  940. 962.4567971229553,
  941. 953.2088260650635,
  942. 940.7230038642883
  943. ],
  944. v1Avg: 8670.831250286103,
  945. v2Avg: 942.0471311569214
  946. }
  947. {
  948. v1Query: 'GetNftsConnection',
  949. v2Query: 'GetNftsConnection',
  950. v1Input: { where: { OR: [Array] }, first: 10, orderBy: 'createdAt_DESC' },
  951. v2Input: {
  952. where: { transactionalStatus: [Object] },
  953. first: 10,
  954. orderBy: 'createdAt_DESC'
  955. },
  956. v1Rows: 10,
  957. v2Rows: 10,
  958. v1Results: [
  959. 247.14272356033325,
  960. 228.97371196746826,
  961. 246.34102869033813,
  962. 212.13250303268433,
  963. 225.15745210647583
  964. ],
  965. v2Results: [
  966. 199.41567182540894,
  967. 174.77051877975464,
  968. 170.97509288787842,
  969. 174.42056322097778,
  970. 181.86301803588867
  971. ],
  972. v1Avg: 231.94948387145996,
  973. v2Avg: 180.28897294998168
  974. }
  975. {
  976. v1Query: 'GetNftsConnection',
  977. v2Query: 'GetNftsConnection',
  978. v1Input: {
  979. where: { creatorChannel: [Object], video: [Object] },
  980. orderBy: 'createdAt_DESC',
  981. first: 50
  982. },
  983. v2Input: { where: { video: [Object] }, orderBy: 'createdAt_DESC', first: 50 },
  984. v1Rows: 50,
  985. v2Rows: 50,
  986. v1Results: [
  987. 826.129762172699,
  988. 827.857581615448,
  989. 800.5643539428711,
  990. 820.9212961196899,
  991. 826.4920339584351
  992. ],
  993. v2Results: [
  994. 300.6907811164856,
  995. 292.02654123306274,
  996. 296.18386602401733,
  997. 297.9059638977051,
  998. 305.9102349281311
  999. ],
  1000. v1Avg: 820.3930055618287,
  1001. v2Avg: 298.54347743988035
  1002. }
  1003. {
  1004. v1Query: 'GetNftsConnection',
  1005. v2Query: 'GetNftsConnection',
  1006. v1Input: { where: { ownerMember: [Object], video: [Object] }, first: 50 },
  1007. v2Input: { where: { OR: [Array] }, first: 50 },
  1008. v1Rows: 50,
  1009. v2Rows: 50,
  1010. v1Results: [
  1011. 842.9543380737305,
  1012. 839.5892696380615,
  1013. 863.8201351165771,
  1014. 821.7399010658264,
  1015. 824.3597412109375
  1016. ],
  1017. v2Results: [
  1018. 448.3910698890686,
  1019. 378.1370120048523,
  1020. 391.88626527786255,
  1021. 385.3741660118103,
  1022. 430.1134309768677
  1023. ],
  1024. v1Avg: 838.4926770210266,
  1025. v2Avg: 406.7803888320923
  1026. }
  1027. {
  1028. v1Query: 'GetNotifications',
  1029. v2Query: 'GetNotifications',
  1030. v1Input: { limit: 50, channelId: '7692', memberId: '2962' },
  1031. v2Input: { limit: 50, channelId: '7692', memberId: '2962' },
  1032. v1Rows: 41,
  1033. v2Rows: 41,
  1034. v1Results: [
  1035. 270.49364709854126,
  1036. 271.6407051086426,
  1037. 279.46371936798096,
  1038. 261.41202783584595,
  1039. 273.94333600997925
  1040. ],
  1041. v2Results: [
  1042. 197.88383102416992,
  1043. 152.39541625976562,
  1044. 177.45843601226807,
  1045. 165.91651725769043,
  1046. 162.6848030090332
  1047. ],
  1048. v1Avg: 271.390687084198,
  1049. v2Avg: 171.26780071258545
  1050. }
  1051. {
  1052. v1Query: 'GetNotifications',
  1053. v2Query: 'GetNotifications',
  1054. v1Input: { limit: 50, channelId: '7693', memberId: '3233' },
  1055. v2Input: { limit: 50, channelId: '7693', memberId: '3233' },
  1056. v1Rows: 46,
  1057. v2Rows: 46,
  1058. v1Results: [
  1059. 323.11878490448,
  1060. 329.5598211288452,
  1061. 339.73275566101074,
  1062. 335.63270902633667,
  1063. 303.4187841415405
  1064. ],
  1065. v2Results: [
  1066. 232.3558349609375,
  1067. 202.4163122177124,
  1068. 204.18560791015625,
  1069. 200.78714323043823,
  1070. 199.25273084640503
  1071. ],
  1072. v1Avg: 326.2925709724426,
  1073. v2Avg: 207.79952583312988
  1074. }
  1075. {
  1076. v1Query: 'GetNftHistory',
  1077. v2Query: 'GetNftHistory',
  1078. v1Input: { nftId: '5' },
  1079. v2Input: { nftId: '5' },
  1080. v1Rows: 20,
  1081. v2Rows: 20,
  1082. v1Results: [
  1083. 173.31935739517212,
  1084. 166.9516897201538,
  1085. 170.40279293060303,
  1086. 174.7423939704895,
  1087. 174.00578212738037
  1088. ],
  1089. v2Results: [
  1090. 150.33283710479736,
  1091. 93.94427919387817,
  1092. 95.62960386276245,
  1093. 101.97420406341553,
  1094. 98.52111673355103
  1095. ],
  1096. v1Avg: 171.88440322875977,
  1097. v2Avg: 108.0804081916809
  1098. }
  1099. {
  1100. v1Query: 'GetNftHistory',
  1101. v2Query: 'GetNftHistory',
  1102. v1Input: { nftId: '14' },
  1103. v2Input: { nftId: '14' },
  1104. v1Rows: 9,
  1105. v2Rows: 9,
  1106. v1Results: [
  1107. 153.43514585494995,
  1108. 152.6274151802063,
  1109. 155.12263679504395,
  1110. 161.05454444885254,
  1111. 158.95368194580078
  1112. ],
  1113. v2Results: [
  1114. 97.54259634017944,
  1115. 94.80965518951416,
  1116. 95.51508903503418,
  1117. 96.91102695465088,
  1118. 93.29117918014526
  1119. ],
  1120. v1Avg: 156.2386848449707,
  1121. v2Avg: 95.61390933990478
  1122. }
  1123. {
  1124. v1Query: 'GetNftHistory',
  1125. v2Query: 'GetNftHistory',
  1126. v1Input: { nftId: '338' },
  1127. v2Input: { nftId: '338' },
  1128. v1Rows: 14,
  1129. v2Rows: 14,
  1130. v1Results: [
  1131. 166.03739500045776,
  1132. 166.7796459197998,
  1133. 172.1448130607605,
  1134. 163.5264310836792,
  1135. 143.60776567459106
  1136. ],
  1137. v2Results: [
  1138. 109.72193622589111,
  1139. 134.63825511932373,
  1140. 94.42882108688354,
  1141. 95.80560684204102,
  1142. 103.1104211807251
  1143. ],
  1144. v1Avg: 162.41921014785765,
  1145. v2Avg: 107.5410080909729
  1146. }
  1147. {
  1148. v1Query: 'GetNftActivities',
  1149. v2Query: 'GetNftActivities',
  1150. v1Input: { limit: 1000, memberId: '4537' },
  1151. v2Input: { limit: 1000, memberId: '4537' },
  1152. v1Rows: 461,
  1153. v2Rows: 461,
  1154. v1Results: [
  1155. 2103.966788291931,
  1156. 1992.9248509407043,
  1157. 1973.9286150932312,
  1158. 1893.4369668960571,
  1159. 1999.6285200119019
  1160. ],
  1161. v2Results: [
  1162. 1804.5559911727905,
  1163. 1809.0813269615173,
  1164. 1753.9034934043884,
  1165. 1761.358551979065,
  1166. 1780.8872237205505
  1167. ],
  1168. v1Avg: 1992.7771482467651,
  1169. v2Avg: 1781.9573174476623
  1170. }
  1171. {
  1172. v1Query: 'GetNftActivities',
  1173. v2Query: 'GetNftActivities',
  1174. v1Input: { limit: 1000, memberId: '798' },
  1175. v2Input: { limit: 1000, memberId: '798' },
  1176. v1Rows: 388,
  1177. v2Rows: 388,
  1178. v1Results: [
  1179. 1810.0302248001099,
  1180. 1788.5535926818848,
  1181. 1733.6757907867432,
  1182. 1667.0256538391113,
  1183. 1631.6055517196655
  1184. ],
  1185. v2Results: [
  1186. 1717.2195363044739,
  1187. 1657.9192810058594,
  1188. 1794.0801358222961,
  1189. 1890.4457349777222,
  1190. 1760.8137216567993
  1191. ],
  1192. v1Avg: 1726.178162765503,
  1193. v2Avg: 1764.0956819534301
  1194. }
  1195. {
  1196. v1Query: 'GetDistributionBucketsWithBags',
  1197. v2Query: 'GetDistributionBucketsWithBags',
  1198. v1Input: undefined,
  1199. v2Input: undefined,
  1200. v1Rows: 16,
  1201. v2Rows: 16,
  1202. v1Results: [
  1203. 6124.845028877258,
  1204. 5903.374890804291,
  1205. 6154.950941085815,
  1206. 5830.3549036979675,
  1207. 6539.96883392334
  1208. ],
  1209. v2Results: [
  1210. 2431.7393584251404,
  1211. 2372.260127067566,
  1212. 2212.2559452056885,
  1213. 2306.838137149811,
  1214. 2271.765986919403
  1215. ],
  1216. v1Avg: 6110.698919677734,
  1217. v2Avg: 2318.9719109535217
  1218. }
  1219. {
  1220. v1Query: 'GetStorageBucketsWithBags',
  1221. v2Query: 'GetStorageBucketsWithBags',
  1222. v1Input: undefined,
  1223. v2Input: undefined,
  1224. v1Rows: 5,
  1225. v2Rows: 5,
  1226. v1Results: [
  1227. 5120.38583612442,
  1228. 5322.9696979522705,
  1229. 4829.539776802063,
  1230. 5126.352346897125,
  1231. 5208.865458011627
  1232. ],
  1233. v2Results: [
  1234. 1804.4636058807373,
  1235. 1778.0691933631897,
  1236. 1564.810200214386,
  1237. 1659.2368817329407,
  1238. 1595.5258312225342
  1239. ],
  1240. v1Avg: 5121.622623157501,
  1241. v2Avg: 1680.4211424827577
  1242. }
  1243. {
  1244. v1Query: 'GetBasicDistributionBuckets',
  1245. v2Query: 'GetBasicDistributionBuckets',
  1246. v1Input: undefined,
  1247. v2Input: undefined,
  1248. v1Rows: 6,
  1249. v2Rows: 6,
  1250. v1Results: [
  1251. 65.99231290817261,
  1252. 56.99334383010864,
  1253. 57.952476978302,
  1254. 57.92965888977051,
  1255. 57.281028270721436
  1256. ],
  1257. v2Results: [
  1258. 52.19367742538452,
  1259. 52.99570608139038,
  1260. 49.56632995605469,
  1261. 54.63258504867554,
  1262. 52.325228691101074
  1263. ],
  1264. v1Avg: 59.22976417541504,
  1265. v2Avg: 52.34270544052124
  1266. }
  1267. {
  1268. v1Query: 'GetBasicStorageBuckets',
  1269. v2Query: 'GetBasicStorageBuckets',
  1270. v1Input: undefined,
  1271. v2Input: undefined,
  1272. v1Rows: 5,
  1273. v2Rows: 5,
  1274. v1Results: [
  1275. 54.4355149269104,
  1276. 58.684725761413574,
  1277. 59.79257535934448,
  1278. 55.931814670562744,
  1279. 53.20528984069824
  1280. ],
  1281. v2Results: [
  1282. 50.20194387435913,
  1283. 51.81971597671509,
  1284. 52.32881784439087,
  1285. 52.80382823944092,
  1286. 51.54786825180054
  1287. ],
  1288. v1Avg: 56.40998411178589,
  1289. v2Avg: 51.74043483734131
  1290. }
  1291. {
  1292. v1Query: 'GetBasicVideosConnection',
  1293. v2Query: 'GetBasicVideosConnection',
  1294. v1Input: {
  1295. where: {
  1296. isPublic_eq: true,
  1297. thumbnailPhoto: [Object],
  1298. media: [Object],
  1299. title_contains: 'a'
  1300. },
  1301. first: 50,
  1302. orderBy: [ 'reactionsCount_DESC', 'commentsCount_DESC', 'createdAt_DESC' ]
  1303. },
  1304. v2Input: {
  1305. where: {
  1306. isPublic_eq: true,
  1307. thumbnailPhoto: [Object],
  1308. media: [Object],
  1309. title_contains: 'a'
  1310. },
  1311. first: 50,
  1312. orderBy: [ 'reactionsCount_DESC', 'commentsCount_DESC', 'createdAt_DESC' ]
  1313. },
  1314. v1Rows: 50,
  1315. v2Rows: 50,
  1316. v1Results: [
  1317. 525.9611740112305,
  1318. 499.14545726776123,
  1319. 472.49702072143555,
  1320. 470.825767993927,
  1321. 479.811487197876
  1322. ],
  1323. v2Results: [
  1324. 132.35848188400269,
  1325. 160.8291997909546,
  1326. 174.8821120262146,
  1327. 212.03918027877808,
  1328. 204.2135772705078
  1329. ],
  1330. v1Avg: 489.64818143844604,
  1331. v2Avg: 176.86451025009154
  1332. }
  1333. {
  1334. v1Query: 'GetBasicVideosConnection',
  1335. v2Query: 'GetBasicVideosConnection',
  1336. v1Input: {
  1337. where: {
  1338. isPublic_eq: true,
  1339. thumbnailPhoto: [Object],
  1340. media: [Object],
  1341. channel: [Object]
  1342. },
  1343. first: 50,
  1344. orderBy: 'createdAt_DESC'
  1345. },
  1346. v2Input: {
  1347. where: {
  1348. isPublic_eq: true,
  1349. thumbnailPhoto: [Object],
  1350. media: [Object],
  1351. channel: [Object]
  1352. },
  1353. first: 50,
  1354. orderBy: 'createdAt_DESC'
  1355. },
  1356. v1Rows: 50,
  1357. v2Rows: 50,
  1358. v1Results: [
  1359. 497.44476413726807,
  1360. 506.4688448905945,
  1361. 551.8768815994263,
  1362. 513.709804058075,
  1363. 534.9751572608948
  1364. ],
  1365. v2Results: [
  1366. 233.6807770729065,
  1367. 230.80591773986816,
  1368. 226.9445719718933,
  1369. 221.15662288665771,
  1370. 228.60488986968994
  1371. ],
  1372. v1Avg: 520.8950903892517,
  1373. v2Avg: 228.23855590820312
  1374. }
  1375. {
  1376. v1Query: 'GetBasicVideos',
  1377. v2Query: 'GetBasicVideos',
  1378. v1Input: { where: {}, limit: 100 },
  1379. v2Input: { where: {}, limit: 100 },
  1380. v1Rows: 100,
  1381. v2Rows: 100,
  1382. v1Results: [
  1383. 971.390682220459,
  1384. 790.1636462211609,
  1385. 781.1701049804688,
  1386. 785.5167179107666,
  1387. 801.3047060966492
  1388. ],
  1389. v2Results: [
  1390. 290.8095955848694,
  1391. 284.5373420715332,
  1392. 272.68615198135376,
  1393. 276.4959993362427,
  1394. 289.1570100784302
  1395. ],
  1396. v1Avg: 825.9091714859009,
  1397. v2Avg: 282.73721981048584
  1398. }
  1399. {
  1400. v1Query: 'GetBasicVideos',
  1401. v2Query: 'GetBasicVideos',
  1402. v1Input: { where: {}, limit: 1000 },
  1403. v2Input: { where: {}, limit: 1000 },
  1404. v1Rows: 805,
  1405. v2Rows: 805,
  1406. v1Results: [
  1407. 5157.266532897949,
  1408. 5299.321074962616,
  1409. 5411.904640197754,
  1410. 5209.753086090088,
  1411. 5391.348983764648
  1412. ],
  1413. v2Results: [
  1414. 746.8637552261353,
  1415. 777.111270904541,
  1416. 751.1737179756165,
  1417. 754.7440190315247,
  1418. 752.4644060134888
  1419. ],
  1420. v1Avg: 5293.918863582611,
  1421. v2Avg: 756.4714338302613
  1422. }
  1423. {
  1424. v1Query: 'GetFullVideo',
  1425. v2Query: 'GetFullVideo',
  1426. v1Input: { where: { id: '5' } },
  1427. v2Input: { id: '5' },
  1428. v1Rows: 1,
  1429. v2Rows: 1,
  1430. v1Results: [
  1431. 85.38859033584595,
  1432. 79.43997383117676,
  1433. 75.47072887420654,
  1434. 77.16838598251343,
  1435. 77.21770429611206
  1436. ],
  1437. v2Results: [
  1438. 105.34136009216309,
  1439. 83.28246402740479,
  1440. 82.277578830719,
  1441. 107.06755495071411,
  1442. 98.24903583526611
  1443. ],
  1444. v1Avg: 78.93707666397094,
  1445. v2Avg: 95.24359874725342
  1446. }
  1447. {
  1448. v1Query: 'GetFullVideo',
  1449. v2Query: 'GetFullVideo',
  1450. v1Input: { where: { id: '338' } },
  1451. v2Input: { id: '338' },
  1452. v1Rows: 1,
  1453. v2Rows: 1,
  1454. v1Results: [
  1455. 73.76963710784912,
  1456. 77.9059386253357,
  1457. 73.89200973510742,
  1458. 76.05835819244385,
  1459. 74.9159460067749
  1460. ],
  1461. v2Results: [
  1462. 83.53682613372803,
  1463. 81.02129364013672,
  1464. 85.55844926834106,
  1465. 83.07700109481812,
  1466. 81.2549238204956
  1467. ],
  1468. v1Avg: 75.3083779335022,
  1469. v2Avg: 82.8896987915039
  1470. }
  1471. {
  1472. v1Query: 'GetFullVideosConnection',
  1473. v2Query: 'GetFullVideosConnection',
  1474. v1Input: {
  1475. first: 50,
  1476. orderBy: 'createdAt_DESC',
  1477. where: { channel: [Object] }
  1478. },
  1479. v2Input: {
  1480. first: 50,
  1481. orderBy: 'createdAt_DESC',
  1482. where: { channel: [Object] }
  1483. },
  1484. v1Rows: 50,
  1485. v2Rows: 50,
  1486. v1Results: [
  1487. 977.525957107544,
  1488. 1022.142493724823,
  1489. 1031.2828168869019,
  1490. 987.822506904602,
  1491. 943.4987850189209
  1492. ],
  1493. v2Results: [
  1494. 326.3035707473755,
  1495. 344.3207583427429,
  1496. 340.7321081161499,
  1497. 340.8959951400757,
  1498. 339.0178442001343
  1499. ],
  1500. v1Avg: 992.4545119285583,
  1501. v2Avg: 338.25405530929567
  1502. }
  1503. {
  1504. v1Query: 'GetFullVideos',
  1505. v2Query: 'GetFullVideos',
  1506. v1Input: { where: {}, limit: 100 },
  1507. v2Input: { where: {}, limit: 100 },
  1508. v1Rows: 100,
  1509. v2Rows: 100,
  1510. v1Results: [
  1511. 1537.1318459510803,
  1512. 1513.86785030365,
  1513. 1515.2559418678284,
  1514. 1585.4749579429626,
  1515. 1562.4298496246338
  1516. ],
  1517. v2Results: [
  1518. 496.73525857925415,
  1519. 480.32121896743774,
  1520. 486.2063159942627,
  1521. 487.0490369796753,
  1522. 508.7582540512085
  1523. ],
  1524. v1Avg: 1542.832089138031,
  1525. v2Avg: 491.8140169143677
  1526. }
  1527. {
  1528. v1Query: 'GetFullVideos',
  1529. v2Query: 'GetFullVideos',
  1530. v1Input: { where: {}, limit: 1000 },
  1531. v2Input: { where: {}, limit: 1000 },
  1532. v1Rows: 805,
  1533. v2Rows: 805,
  1534. v1Results: [
  1535. 11362.29087638855,
  1536. 11582.575244903564,
  1537. 11715.4169216156,
  1538. 12441.800940990448,
  1539. 12011.797077178955
  1540. ],
  1541. v2Results: [
  1542. 1775.348120212555,
  1543. 1893.0316281318665,
  1544. 1878.4460277557373,
  1545. 1792.5191836357117,
  1546. 1767.898630142212
  1547. ],
  1548. v1Avg: 11822.776212215424,
  1549. v2Avg: 1821.4487179756165
  1550. }
  1551. {
  1552. v1Query: 'GetMetaprotocolTransactionStatusEvents',
  1553. v2Query: 'GetMetaprotocolTransactionStatusEvents',
  1554. v1Input: {
  1555. transactionHash: '0x536d93a5e19c48d6f5983c8de3b9622fe44d096f13698aa2c13e8ae0f8a62780'
  1556. },
  1557. v2Input: {
  1558. transactionHash: '0x536d93a5e19c48d6f5983c8de3b9622fe44d096f13698aa2c13e8ae0f8a62780'
  1559. },
  1560. v1Rows: 1,
  1561. v2Rows: 1,
  1562. v1Results: [
  1563. 76.09493684768677,
  1564. 61.26659393310547,
  1565. 67.08289289474487,
  1566. 62.03224325180054,
  1567. 62.84442472457886
  1568. ],
  1569. v2Results: [
  1570. 99.51310014724731,
  1571. 75.71026611328125,
  1572. 78.08668994903564,
  1573. 77.9978232383728,
  1574. 75.89909315109253
  1575. ],
  1576. v1Avg: 65.8642183303833,
  1577. v2Avg: 81.44139451980591
  1578. }
  1579. {
  1580. v1Query: 'GetMostViewedVideosConnection',
  1581. v2Query: 'GetMostViewedVideosConnection',
  1582. v1Input: {
  1583. periodDays: 30,
  1584. orderBy: 'createdAt_DESC',
  1585. where: { isPublic_eq: true, thumbnailPhoto: [Object], media: [Object] }
  1586. },
  1587. v2Input: {
  1588. periodDays: 30,
  1589. orderBy: 'createdAt_DESC',
  1590. where: {
  1591. isPublic_eq: true,
  1592. thumbnailPhoto: [Object],
  1593. media: [Object],
  1594. viewsNum_gt: 0
  1595. }
  1596. },
  1597. v1Rows: 0,
  1598. v2Rows: 0,
  1599. v1Results: [
  1600. 80.48915433883667,
  1601. 65.49996328353882,
  1602. 61.12476396560669,
  1603. 62.614012241363525,
  1604. 64.81580972671509
  1605. ],
  1606. v2Results: [
  1607. 106.05631828308105,
  1608. 93.0529899597168,
  1609. 87.02544689178467,
  1610. 90.3436050415039,
  1611. 88.66995906829834
  1612. ],
  1613. v1Avg: 66.90874071121216,
  1614. v2Avg: 93.02966384887695
  1615. }
  1616. {
  1617. v1Query: 'GetMostViewedVideosConnection',
  1618. v2Query: 'GetMostViewedVideosConnection',
  1619. v1Input: {
  1620. periodDays: 7,
  1621. orderBy: 'createdAt_DESC',
  1622. where: { isPublic_eq: true, thumbnailPhoto: [Object], media: [Object] }
  1623. },
  1624. v2Input: {
  1625. periodDays: 7,
  1626. orderBy: 'createdAt_DESC',
  1627. where: {
  1628. isPublic_eq: true,
  1629. thumbnailPhoto: [Object],
  1630. media: [Object],
  1631. viewsNum_gt: 0
  1632. }
  1633. },
  1634. v1Rows: 0,
  1635. v2Rows: 0,
  1636. v1Results: [
  1637. 66.27537775039673,
  1638. 72.85521984100342,
  1639. 64.4862608909607,
  1640. 66.47858428955078,
  1641. 65.51822805404663
  1642. ],
  1643. v2Results: [
  1644. 83.86245536804199,
  1645. 85.17027282714844,
  1646. 86.42342805862427,
  1647. 88.33325576782227,
  1648. 178.35977792739868
  1649. ],
  1650. v1Avg: 67.12273416519164,
  1651. v2Avg: 104.42983798980713
  1652. }
  1653. {
  1654. v1Query: 'GetTop10VideosThisMonth',
  1655. v2Query: 'GetTop10VideosThisMonth',
  1656. v1Input: {
  1657. where: { isPublic_eq: true, thumbnailPhoto: [Object], media: [Object] }
  1658. },
  1659. v2Input: {
  1660. where: {
  1661. isPublic_eq: true,
  1662. thumbnailPhoto: [Object],
  1663. media: [Object],
  1664. viewsNum_gt: 0
  1665. }
  1666. },
  1667. v1Rows: 0,
  1668. v2Rows: 0,
  1669. v1Results: [
  1670. 60.40868091583252,
  1671. 63.82251024246216,
  1672. 59.40767812728882,
  1673. 60.54756689071655,
  1674. 60.28232717514038
  1675. ],
  1676. v2Results: [
  1677. 103.657479763031,
  1678. 81.3549427986145,
  1679. 81.7249755859375,
  1680. 82.16871070861816,
  1681. 80.46699285507202
  1682. ],
  1683. v1Avg: 60.89375267028809,
  1684. v2Avg: 85.87462034225464
  1685. }
  1686. {
  1687. v1Query: 'GetTop10VideosThisWeek',
  1688. v2Query: 'GetTop10VideosThisWeek',
  1689. v1Input: {
  1690. where: { isPublic_eq: true, thumbnailPhoto: [Object], media: [Object] }
  1691. },
  1692. v2Input: {
  1693. where: {
  1694. isPublic_eq: true,
  1695. thumbnailPhoto: [Object],
  1696. media: [Object],
  1697. viewsNum_gt: 0
  1698. }
  1699. },
  1700. v1Rows: 0,
  1701. v2Rows: 0,
  1702. v1Results: [
  1703. 71.49823474884033,
  1704. 57.3078031539917,
  1705. 59.002439975738525,
  1706. 71.05788040161133,
  1707. 58.2105827331543
  1708. ],
  1709. v2Results: [
  1710. 94.3049201965332,
  1711. 82.18999814987183,
  1712. 80.69693517684937,
  1713. 85.2896900177002,
  1714. 78.74044990539551
  1715. ],
  1716. v1Avg: 63.41538820266724,
  1717. v2Avg: 84.24439868927001
  1718. }
  1719. ========= QUERIES IN 0ms - Infinity RANGE =========
  1720. Tested queries in this range: 63
  1721. On average, the average improvement in query execution time in Orion v2 vs Orion v1 is: 102.42%
  1722. The median of average improvement in query execution time in Orion v2 vs Orion v1 is: 42.12%
  1723. On average, the median improvement in query execution time in Orion v2 vs Orion v1 is: 104.30%
  1724. The median of median improvement in query execution time in Orion v2 vs Orion v1 is: 45.95%
  1725. ========= QUERIES IN 0ms - 100ms RANGE =========
  1726. Tested queries in this range: 26
  1727. On average, the average improvement in query execution time in Orion v2 vs Orion v1 is: -5.54%
  1728. The median of average improvement in query execution time in Orion v2 vs Orion v1 is: -0.76%
  1729. On average, the median improvement in query execution time in Orion v2 vs Orion v1 is: -3.96%
  1730. The median of median improvement in query execution time in Orion v2 vs Orion v1 is: 0.76%
  1731. ========= QUERIES IN 101ms - 500ms RANGE =========
  1732. Tested queries in this range: 19
  1733. On average, the average improvement in query execution time in Orion v2 vs Orion v1 is: 81.62%
  1734. The median of average improvement in query execution time in Orion v2 vs Orion v1 is: 69.34%
  1735. On average, the median improvement in query execution time in Orion v2 vs Orion v1 is: 83.95%
  1736. The median of median improvement in query execution time in Orion v2 vs Orion v1 is: 72.39%
  1737. ========= QUERIES IN 501ms - 2000ms RANGE =========
  1738. Tested queries in this range: 10
  1739. On average, the average improvement in query execution time in Orion v2 vs Orion v1 is: 142.35%
  1740. The median of average improvement in query execution time in Orion v2 vs Orion v1 is: 170.29%
  1741. On average, the median improvement in query execution time in Orion v2 vs Orion v1 is: 146.00%
  1742. The median of median improvement in query execution time in Orion v2 vs Orion v1 is: 177.51%
  1743. ========= QUERIES IN 2000ms - Infinity RANGE =========
  1744. Tested queries in this range: 7
  1745. On average, the average improvement in query execution time in Orion v2 vs Orion v1 is: 512.14%
  1746. The median of average improvement in query execution time in Orion v2 vs Orion v1 is: 549.09%
  1747. On average, the median improvement in query execution time in Orion v2 vs Orion v1 is: 511.71%
  1748. The median of median improvement in query execution time in Orion v2 vs Orion v1 is: 553.57%