benchmark_result_with_events 39 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752
  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. 421.19117879867554,
  12. 163.13986778259277,
  13. 129.42280769348145,
  14. 112.2303056716919,
  15. 118.83463382720947
  16. ],
  17. v2Results: [
  18. 303.17519998550415,
  19. 66.7838659286499,
  20. 72.47513008117676,
  21. 68.80956888198853,
  22. 65.30918073654175
  23. ],
  24. v1Avg: 188.96375875473024,
  25. v2Avg: 115.31058912277221
  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. 93.11739826202393,
  36. 87.66728019714355,
  37. 92.8959321975708,
  38. 89.85720205307007,
  39. 84.56506490707397
  40. ],
  41. v2Results: [
  42. 71.88657188415527,
  43. 64.33595418930054,
  44. 62.170491218566895,
  45. 65.18707704544067,
  46. 62.554245948791504
  47. ],
  48. v1Avg: 89.62057552337646,
  49. v2Avg: 65.22686805725098
  50. }
  51. {
  52. v1Query: 'GetBids',
  53. v2Query: 'GetBids',
  54. v1Input: { where: {}, limit: 100 },
  55. v2Input: { where: {}, limit: 100 },
  56. v1Rows: 53,
  57. v2Rows: 53,
  58. v1Results: [
  59. 317.4668221473694,
  60. 278.0240716934204,
  61. 273.81632566452026,
  62. 335.95528411865234,
  63. 249.63872814178467
  64. ],
  65. v2Results: [
  66. 131.43993282318115,
  67. 148.3516411781311,
  68. 120.04446029663086,
  69. 125.5801887512207,
  70. 121.84051084518433
  71. ],
  72. v1Avg: 290.9802463531494,
  73. v2Avg: 129.45134677886963
  74. }
  75. {
  76. v1Query: 'GetVideoCategories',
  77. v2Query: 'GetExtendedVideoCategories',
  78. v1Input: undefined,
  79. v2Input: undefined,
  80. v1Rows: 29,
  81. v2Rows: 29,
  82. v1Results: [
  83. 66.14623975753784,
  84. 62.87800598144531,
  85. 63.253201961517334,
  86. 66.02718687057495,
  87. 66.30277585983276
  88. ],
  89. v2Results: [
  90. 69.70861482620239,
  91. 62.85316276550293,
  92. 62.281888008117676,
  93. 62.330246925354004,
  94. 59.7666449546814
  95. ],
  96. v1Avg: 64.92148208618164,
  97. v2Avg: 63.38811149597168
  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. 83.8572268486023,
  108. 71.72754001617432,
  109. 74.71778678894043,
  110. 75.86461400985718,
  111. 70.17161130905151
  112. ],
  113. v2Results: [
  114. 63.21177434921265,
  115. 66.28264999389648,
  116. 60.33377170562744,
  117. 72.96462726593018,
  118. 62.06374216079712
  119. ],
  120. v1Avg: 75.26775579452514,
  121. v2Avg: 64.97131309509277
  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. 74.74455785751343,
  132. 66.66368865966797,
  133. 66.95752286911011,
  134. 72.04269599914551,
  135. 71.53086280822754
  136. ],
  137. v2Results: [
  138. 68.04775190353394,
  139. 66.37166786193848,
  140. 66.88651609420776,
  141. 64.02910900115967,
  142. 63.339770793914795
  143. ],
  144. v1Avg: 70.3878656387329,
  145. v2Avg: 65.73496313095093
  146. }
  147. {
  148. v1Query: 'GetVideoCount',
  149. v2Query: 'GetVideoCount',
  150. v1Input: { where: {} },
  151. v2Input: { where: {} },
  152. v1Rows: 1,
  153. v2Rows: 1,
  154. v1Results: [
  155. 68.7070541381836,
  156. 62.03211736679077,
  157. 61.3677396774292,
  158. 66.51247310638428,
  159. 64.52027893066406
  160. ],
  161. v2Results: [
  162. 59.809531688690186,
  163. 62.72549486160278,
  164. 56.092894077301025,
  165. 61.54808282852173,
  166. 57.137871742248535
  167. ],
  168. v1Avg: 64.62793264389038,
  169. v2Avg: 59.46277503967285
  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: 44,
  185. v2Rows: 44,
  186. v1Results: [
  187. 153.39953422546387,
  188. 144.06597089767456,
  189. 128.5862011909485,
  190. 145.6520037651062,
  191. 156.21932363510132
  192. ],
  193. v2Results: [
  194. 71.88532161712646,
  195. 74.65329265594482,
  196. 69.77712488174438,
  197. 75.77475929260254,
  198. 74.50010061264038
  199. ],
  200. v1Avg: 145.58460674285888,
  201. v2Avg: 73.31811981201172
  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. 178.52417182922363,
  212. 159.60775184631348,
  213. 228.59030675888062,
  214. 237.02427005767822,
  215. 205.4558572769165
  216. ],
  217. v2Results: [
  218. 177.8631992340088,
  219. 175.88821125030518,
  220. 175.75369501113892,
  221. 174.07207679748535,
  222. 170.09397506713867
  223. ],
  224. v1Avg: 201.8404715538025,
  225. v2Avg: 174.73423147201538
  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. 1250.8551998138428,
  236. 1245.4255104064941,
  237. 1107.5180191993713,
  238. 1023.1205387115479,
  239. 1052.9191160202026
  240. ],
  241. v2Results: [
  242. 530.5339818000793,
  243. 493.39230489730835,
  244. 519.6276531219482,
  245. 472.1422986984253,
  246. 462.8647699356079
  247. ],
  248. v1Avg: 1135.9676768302918,
  249. v2Avg: 495.71220169067385
  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. 208.32790184020996,
  260. 198.79837894439697,
  261. 187.45538902282715,
  262. 196.41755199432373,
  263. 210.31847763061523
  264. ],
  265. v2Results: [
  266. 131.9381880760193,
  267. 132.50413179397583,
  268. 132.07942390441895,
  269. 128.79442358016968,
  270. 129.5107011795044
  271. ],
  272. v1Avg: 200.2635398864746,
  273. v2Avg: 130.96537370681762
  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. 485.90900897979736,
  284. 502.74723529815674,
  285. 493.8253450393677,
  286. 483.21063232421875,
  287. 496.1202321052551
  288. ],
  289. v2Results: [
  290. 309.2644462585449,
  291. 299.81357431411743,
  292. 306.3402919769287,
  293. 305.5112318992615,
  294. 303.7119936943054
  295. ],
  296. v1Avg: 492.36249074935915,
  297. v2Avg: 304.9283076286316
  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. 3857.2243642807007,
  308. 3745.495181083679,
  309. 3712.0744309425354,
  310. 3826.4734230041504,
  311. 3805.3891520500183
  312. ],
  313. v2Results: [
  314. 784.2543258666992,
  315. 707.6921191215515,
  316. 716.5077013969421,
  317. 686.4854230880737,
  318. 655.8917288780212
  319. ],
  320. v1Avg: 3789.331310272217,
  321. v2Avg: 710.1662596702575
  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. 214.1855297088623,
  338. 217.18303966522217,
  339. 163.2842240333557,
  340. 156.80159616470337,
  341. 162.413010597229
  342. ],
  343. v2Results: [
  344. 134.21514558792114,
  345. 82.55778789520264,
  346. 74.47067975997925,
  347. 79.15636014938354,
  348. 76.05493497848511
  349. ],
  350. v1Avg: 182.7734800338745,
  351. v2Avg: 89.29098167419434
  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.938393115997314,
  362. 61.32223463058472,
  363. 60.94342231750488,
  364. 62.37822914123535,
  365. 63.58266305923462
  366. ],
  367. v2Results: [
  368. 62.01163101196289,
  369. 67.39911794662476,
  370. 66.93669319152832,
  371. 65.62528800964355,
  372. 64.97405576705933
  373. ],
  374. v1Avg: 60.83298845291138,
  375. v2Avg: 65.38935718536376
  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. 113.39564800262451,
  386. 110.71231603622437,
  387. 109.02454137802124,
  388. 106.11804294586182,
  389. 114.78720283508301
  390. ],
  391. v2Results: [
  392. 71.7989239692688,
  393. 70.08385801315308,
  394. 67.92963790893555,
  395. 68.35090732574463,
  396. 60.26752471923828
  397. ],
  398. v1Avg: 110.80755023956299,
  399. v2Avg: 67.68617038726806
  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. 123.49010276794434,
  410. 109.52056121826172,
  411. 106.4278359413147,
  412. 120.96437168121338,
  413. 108.74368190765381
  414. ],
  415. v2Results: [
  416. 61.793911933898926,
  417. 63.35046911239624,
  418. 62.705503940582275,
  419. 65.86193895339966,
  420. 66.9338231086731
  421. ],
  422. v1Avg: 113.82931070327759,
  423. v2Avg: 64.12912940979004
  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. 59.21133518218994,
  434. 63.312808990478516,
  435. 63.60664987564087,
  436. 63.77114772796631,
  437. 63.40945339202881
  438. ],
  439. v2Results: [
  440. 66.12633466720581,
  441. 63.418736934661865,
  442. 67.53504800796509,
  443. 66.23921203613281,
  444. 67.21646881103516
  445. ],
  446. v1Avg: 62.66227903366089,
  447. v2Avg: 66.10716009140015
  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. 80.18467807769775,
  458. 80.11003303527832,
  459. 79.54493618011475,
  460. 80.00109958648682,
  461. 76.3753080368042
  462. ],
  463. v2Results: [
  464. 66.85215425491333,
  465. 65.3834400177002,
  466. 70.74419927597046,
  467. 66.57812309265137,
  468. 64.34331178665161
  469. ],
  470. v1Avg: 79.24321098327637,
  471. v2Avg: 66.7802456855774
  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. 70.87953805923462,
  482. 63.640191078186035,
  483. 66.02025079727173,
  484. 65.73933982849121,
  485. 69.7096381187439
  486. ],
  487. v2Results: [
  488. 65.14625787734985,
  489. 54.67692708969116,
  490. 65.20886325836182,
  491. 67.9664740562439,
  492. 63.1194429397583
  493. ],
  494. v1Avg: 67.1977915763855,
  495. v2Avg: 63.223593044281
  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. 77.05896615982056,
  514. 73.91739177703857,
  515. 75.00851917266846,
  516. 77.64734125137329,
  517. 67.86735820770264
  518. ],
  519. v2Results: [
  520. 65.73792362213135,
  521. 62.08174705505371,
  522. 67.16134023666382,
  523. 63.9364218711853,
  524. 63.95925998687744
  525. ],
  526. v1Avg: 74.2999153137207,
  527. v2Avg: 64.57533855438233
  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. 105.49908971786499,
  548. 102.58012008666992,
  549. 105.23410272598267,
  550. 102.98625087738037,
  551. 99.61199808120728
  552. ],
  553. v2Results: [
  554. 70.75768566131592,
  555. 72.2657117843628,
  556. 78.56287240982056,
  557. 78.20898723602295,
  558. 68.45703983306885
  559. ],
  560. v1Avg: 103.18231229782104,
  561. v2Avg: 73.65045938491821
  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. 70.73677730560303,
  572. 59.36874198913574,
  573. 64.62766218185425,
  574. 60.28378677368164,
  575. 64.39493083953857
  576. ],
  577. v2Results: [
  578. 64.25262498855591,
  579. 58.87449932098389,
  580. 62.75416707992554,
  581. 53.005496978759766,
  582. 58.40084886550903
  583. ],
  584. v1Avg: 63.882379817962644,
  585. v2Avg: 59.45752744674682
  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. 72.38071393966675,
  596. 69.33194017410278,
  597. 72.78404188156128,
  598. 67.04246520996094,
  599. 67.23769807815552
  600. ],
  601. v2Results: [
  602. 68.29141330718994,
  603. 63.38331079483032,
  604. 62.78171491622925,
  605. 74.58481168746948,
  606. 60.97283315658569
  607. ],
  608. v1Avg: 69.75537185668945,
  609. v2Avg: 66.00281677246093
  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. 73.34512376785278,
  634. 58.2767858505249,
  635. 62.86376714706421,
  636. 64.79999113082886,
  637. 61.0808687210083
  638. ],
  639. v2Results: [
  640. 50.125935077667236,
  641. 52.19748115539551,
  642. 53.763554096221924,
  643. 55.75706720352173,
  644. 54.293893337249756
  645. ],
  646. v1Avg: 64.07330732345581,
  647. v2Avg: 53.22758617401123
  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. 72.63295412063599,
  686. 69.48676872253418,
  687. 76.58421277999878,
  688. 76.11389541625977,
  689. 74.24702644348145
  690. ],
  691. v2Results: [
  692. 59.706161975860596,
  693. 58.827009201049805,
  694. 61.6181902885437,
  695. 58.3860502243042,
  696. 58.34018087387085
  697. ],
  698. v1Avg: 73.81297149658204,
  699. v2Avg: 59.37551851272583
  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. 142.06596088409424,
  740. 122.80291080474854,
  741. 122.27795839309692,
  742. 119.0836591720581,
  743. 134.74790716171265
  744. ],
  745. v2Results: [
  746. 76.70351982116699,
  747. 66.95917177200317,
  748. 66.27426624298096,
  749. 69.28363800048828,
  750. 74.81394481658936
  751. ],
  752. v1Avg: 128.19567928314208,
  753. v2Avg: 70.80690813064575
  754. }
  755. {
  756. v1Query: 'GetAllCategoriesFeaturedVideos',
  757. v2Query: 'GetAllCategoriesFeaturedVideos',
  758. v1Input: undefined,
  759. v2Input: undefined,
  760. v1Rows: 0,
  761. v2Rows: 0,
  762. v1Results: [
  763. 67.76015424728394,
  764. 59.42477512359619,
  765. 56.76981830596924,
  766. 51.056944847106934,
  767. 59.30195999145508
  768. ],
  769. v2Results: [
  770. 93.6363000869751,
  771. 83.03214597702026,
  772. 78.39022636413574,
  773. 79.9343843460083,
  774. 77.40477991104126
  775. ],
  776. v1Avg: 58.862730503082275,
  777. v2Avg: 82.47956733703613
  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. 214.15404987335205,
  788. 182.97863626480103,
  789. 184.82217597961426,
  790. 186.02766466140747,
  791. 182.85374784469604
  792. ],
  793. v2Results: [
  794. 66.20597267150879,
  795. 70.55012226104736,
  796. 67.13733291625977,
  797. 64.06079912185669,
  798. 70.39453220367432
  799. ],
  800. v1Avg: 190.16725492477417,
  801. v2Avg: 67.66975183486939
  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. 333.6070990562439,
  812. 314.0952458381653,
  813. 327.9120593070984,
  814. 315.27012825012207,
  815. 331.3791127204895
  816. ],
  817. v2Results: [
  818. 127.5027551651001,
  819. 142.95735788345337,
  820. 123.67933082580566,
  821. 123.08590698242188,
  822. 121.60571765899658
  823. ],
  824. v1Avg: 324.45272903442384,
  825. v2Avg: 127.76621370315551
  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. 30849.73528432846,
  836. 31882.469860076904,
  837. 31109.63481903076,
  838. 30614.91681098938,
  839. 30950.97841501236
  840. ],
  841. v2Results: [
  842. 3052.7483744621277,
  843. 3554.0164704322815,
  844. 3415.2259860038757,
  845. 3284.211546897888,
  846. 3351.091986179352
  847. ],
  848. v1Avg: 31081.547037887573,
  849. v2Avg: 3331.458872795105
  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. 94.42390012741089,
  860. 70.99061298370361,
  861. 75.04313135147095,
  862. 83.69558477401733,
  863. 87.41263914108276
  864. ],
  865. v2Results: [
  866. 109.23487997055054,
  867. 84.78160381317139,
  868. 92.18809795379639,
  869. 97.03550100326538,
  870. 113.14659595489502
  871. ],
  872. v1Avg: 82.31317367553712,
  873. v2Avg: 99.27733573913574
  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. 81.1192569732666,
  884. 77.66667985916138,
  885. 72.31310892105103,
  886. 71.75890016555786,
  887. 77.78996515274048
  888. ],
  889. v2Results: [
  890. 95.35447025299072,
  891. 96.32403326034546,
  892. 100.6230821609497,
  893. 99.6693344116211,
  894. 91.5633659362793
  895. ],
  896. v1Avg: 76.12958221435547,
  897. v2Avg: 96.70685720443726
  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. 1516.715693950653,
  908. 1485.822862148285,
  909. 1415.5554280281067,
  910. 1408.7918581962585,
  911. 1422.4151797294617
  912. ],
  913. v2Results: [
  914. 419.95120096206665,
  915. 469.25443172454834,
  916. 434.8049511909485,
  917. 433.76535415649414,
  918. 422.5718607902527
  919. ],
  920. v1Avg: 1449.860204410553,
  921. v2Avg: 436.06955976486205
  922. }
  923. {
  924. v1Query: 'GetNfts',
  925. v2Query: 'GetNfts',
  926. v1Input: { where: {}, limit: 1000 },
  927. v2Input: { where: {}, limit: 1000 },
  928. v1Rows: 632,
  929. v2Rows: 632,
  930. v1Results: [
  931. 8736.58143901825,
  932. 8027.877285003662,
  933. 8017.714208126068,
  934. 8199.404845237732,
  935. 8273.757127285004
  936. ],
  937. v2Results: [
  938. 1138.7621746063232,
  939. 979.259006023407,
  940. 1213.139995098114,
  941. 984.5032978057861,
  942. 1217.3297839164734
  943. ],
  944. v1Avg: 8251.066980934143,
  945. v2Avg: 1106.5988514900207
  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. 208.1110258102417,
  960. 188.20164489746094,
  961. 186.994038105011,
  962. 189.2771201133728,
  963. 196.83653688430786
  964. ],
  965. v2Results: [
  966. 194.6592321395874,
  967. 174.11980724334717,
  968. 225.97443199157715,
  969. 182.2728977203369,
  970. 186.91593599319458
  971. ],
  972. v1Avg: 193.88407316207886,
  973. v2Avg: 192.78846101760865
  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. 875.5980272293091,
  988. 867.5878348350525,
  989. 890.464898109436,
  990. 892.9318900108337,
  991. 867.7934184074402
  992. ],
  993. v2Results: [
  994. 337.6217017173767,
  995. 362.4307789802551,
  996. 334.556293964386,
  997. 306.31625509262085,
  998. 332.5812349319458
  999. ],
  1000. v1Avg: 878.8752137184143,
  1001. v2Avg: 334.7012529373169
  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. 892.9570322036743,
  1012. 853.0992479324341,
  1013. 877.8199729919434,
  1014. 878.872606754303,
  1015. 992.4630327224731
  1016. ],
  1017. v2Results: [
  1018. 435.7008147239685,
  1019. 441.5585136413574,
  1020. 461.15005588531494,
  1021. 415.9951968193054,
  1022. 426.98348331451416
  1023. ],
  1024. v1Avg: 899.0423785209656,
  1025. v2Avg: 436.2776128768921
  1026. }
  1027. {
  1028. v1Query: 'GetNotifications',
  1029. v2Query: 'GetNotifications',
  1030. v1Input: { limit: 1000, channelId: '7757', memberId: '798' },
  1031. v2Input: { limit: 1000, channelId: '7757', memberId: '798' },
  1032. v1Rows: 107,
  1033. v2Rows: 107,
  1034. v1Results: [
  1035. 550.4048280715942,
  1036. 501.2757987976074,
  1037. 487.1333951950073,
  1038. 536.0914778709412,
  1039. 498.24291229248047
  1040. ],
  1041. v2Results: [
  1042. 1445.486295223236,
  1043. 1389.0695791244507,
  1044. 1383.3935737609863,
  1045. 1513.5665192604065,
  1046. 1456.1625089645386
  1047. ],
  1048. v1Avg: 514.6296824455261,
  1049. v2Avg: 1437.5356952667237
  1050. }
  1051. {
  1052. v1Query: 'GetNotifications',
  1053. v2Query: 'GetNotifications',
  1054. v1Input: { limit: 1000, channelId: '7692', memberId: '2962' },
  1055. v2Input: { limit: 1000, channelId: '7692', memberId: '2962' },
  1056. v1Rows: 37,
  1057. v2Rows: 37,
  1058. v1Results: [
  1059. 282.56104803085327,
  1060. 284.16384506225586,
  1061. 294.0263376235962,
  1062. 274.5316801071167,
  1063. 291.8484048843384
  1064. ],
  1065. v2Results: [
  1066. 1421.9847450256348,
  1067. 1498.7254118919373,
  1068. 1386.1704230308533,
  1069. 1420.0155906677246,
  1070. 1395.3243989944458
  1071. ],
  1072. v1Avg: 285.4262631416321,
  1073. v2Avg: 1424.4441139221192
  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. 200.89012718200684,
  1084. 173.88734912872314,
  1085. 196.80633020401,
  1086. 179.11635303497314,
  1087. 170.6115379333496
  1088. ],
  1089. v2Results: [
  1090. 1104.4836640357971,
  1091. 1094.294376373291,
  1092. 1054.3348608016968,
  1093. 1164.1998901367188,
  1094. 1105.8195872306824
  1095. ],
  1096. v1Avg: 184.26233949661255,
  1097. v2Avg: 1104.6264757156373
  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. 178.28355407714844,
  1108. 166.6809320449829,
  1109. 149.1403203010559,
  1110. 157.61766910552979,
  1111. 164.93955421447754
  1112. ],
  1113. v2Results: [
  1114. 1095.4141011238098,
  1115. 1073.3860268592834,
  1116. 1127.3224921226501,
  1117. 1098.5844469070435,
  1118. 1048.8867902755737
  1119. ],
  1120. v1Avg: 163.33240594863892,
  1121. v2Avg: 1088.7187714576721
  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. 169.1531286239624,
  1132. 166.22336101531982,
  1133. 177.1820297241211,
  1134. 157.99354791641235,
  1135. 160.28074312210083
  1136. ],
  1137. v2Results: [
  1138. 1043.0286660194397,
  1139. 1114.5620112419128,
  1140. 1045.9608130455017,
  1141. 1039.3346590995789,
  1142. 1046.5136580467224
  1143. ],
  1144. v1Avg: 166.1665620803833,
  1145. v2Avg: 1057.879961490631
  1146. }
  1147. {
  1148. v1Query: 'GetNftActivities',
  1149. v2Query: 'GetNftActivities',
  1150. v1Input: { limit: 1000, memberId: '4537' },
  1151. v2Input: { limit: 1000, memberId: '4537' },
  1152. v1Rows: 446,
  1153. v2Rows: 450,
  1154. v1Results: [
  1155. 1985.1007766723633,
  1156. 2020.4005188941956,
  1157. 2353.54096698761,
  1158. 2108.218147277832,
  1159. 2028.2483730316162
  1160. ],
  1161. v2Results: [
  1162. 4557.656895160675,
  1163. 4586.954351902008,
  1164. 4777.58341884613,
  1165. 4669.475918769836,
  1166. 4621.450538158417
  1167. ],
  1168. v1Avg: 2099.1017565727234,
  1169. v2Avg: 4642.624224567413
  1170. }
  1171. {
  1172. v1Query: 'GetNftActivities',
  1173. v2Query: 'GetNftActivities',
  1174. v1Input: { limit: 1000, memberId: '798' },
  1175. v2Input: { limit: 1000, memberId: '798' },
  1176. v1Rows: 376,
  1177. v2Rows: 380,
  1178. v1Results: [
  1179. 1906.9350337982178,
  1180. 1820.815878868103,
  1181. 1861.610330581665,
  1182. 1833.0889353752136,
  1183. 1814.4130339622498
  1184. ],
  1185. v2Results: [
  1186. 4557.399219989777,
  1187. 4331.383925914764,
  1188. 4329.167932033539,
  1189. 4256.457892894745,
  1190. 4419.476686954498
  1191. ],
  1192. v1Avg: 1847.3726425170898,
  1193. v2Avg: 4378.777131557465
  1194. }
  1195. {
  1196. v1Query: 'GetDistributionBucketsWithBags',
  1197. v2Query: 'GetDistributionBucketsWithBags',
  1198. v1Input: undefined,
  1199. v2Input: undefined,
  1200. v1Rows: 16,
  1201. v2Rows: 16,
  1202. v1Results: [
  1203. 6441.058031082153,
  1204. 6398.98236989975,
  1205. 6046.677813053131,
  1206. 6166.344225883484,
  1207. 6210.616687774658
  1208. ],
  1209. v2Results: [
  1210. 2527.584487915039,
  1211. 2693.8000507354736,
  1212. 2536.3556418418884,
  1213. 2669.446587085724,
  1214. 2373.4409008026123
  1215. ],
  1216. v1Avg: 6252.735825538635,
  1217. v2Avg: 2560.1255336761474
  1218. }
  1219. {
  1220. v1Query: 'GetStorageBucketsWithBags',
  1221. v2Query: 'GetStorageBucketsWithBags',
  1222. v1Input: undefined,
  1223. v2Input: undefined,
  1224. v1Rows: 5,
  1225. v2Rows: 5,
  1226. v1Results: [
  1227. 5082.594819068909,
  1228. 5243.263826847076,
  1229. 5185.951680183411,
  1230. 5148.845768928528,
  1231. 5430.089545726776
  1232. ],
  1233. v2Results: [
  1234. 2183.454391002655,
  1235. 1859.054081916809,
  1236. 2085.4263796806335,
  1237. 1877.52525806427,
  1238. 1752.7501153945923
  1239. ],
  1240. v1Avg: 5218.14912815094,
  1241. v2Avg: 1951.642045211792
  1242. }
  1243. {
  1244. v1Query: 'GetBasicDistributionBuckets',
  1245. v2Query: 'GetBasicDistributionBuckets',
  1246. v1Input: undefined,
  1247. v2Input: undefined,
  1248. v1Rows: 6,
  1249. v2Rows: 6,
  1250. v1Results: [
  1251. 71.7662091255188,
  1252. 62.67876386642456,
  1253. 67.08984804153442,
  1254. 62.062345027923584,
  1255. 64.87987995147705
  1256. ],
  1257. v2Results: [
  1258. 58.704387187957764,
  1259. 57.185120582580566,
  1260. 56.77264070510864,
  1261. 55.178711891174316,
  1262. 52.652371883392334
  1263. ],
  1264. v1Avg: 65.69540920257569,
  1265. v2Avg: 56.09864645004272
  1266. }
  1267. {
  1268. v1Query: 'GetBasicStorageBuckets',
  1269. v2Query: 'GetBasicStorageBuckets',
  1270. v1Input: undefined,
  1271. v2Input: undefined,
  1272. v1Rows: 5,
  1273. v2Rows: 5,
  1274. v1Results: [
  1275. 61.25364637374878,
  1276. 59.18447017669678,
  1277. 61.45736217498779,
  1278. 62.92768669128418,
  1279. 63.0603461265564
  1280. ],
  1281. v2Results: [
  1282. 52.754788875579834,
  1283. 59.61000728607178,
  1284. 56.9753942489624,
  1285. 56.309372901916504,
  1286. 56.9772629737854
  1287. ],
  1288. v1Avg: 61.57670230865479,
  1289. v2Avg: 56.52536525726318
  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. 539.3446879386902,
  1318. 517.5640339851379,
  1319. 498.5641589164734,
  1320. 505.30816411972046,
  1321. 499.96891593933105
  1322. ],
  1323. v2Results: [
  1324. 129.79853200912476,
  1325. 124.13662338256836,
  1326. 179.8704071044922,
  1327. 232.50274515151978,
  1328. 219.74482917785645
  1329. ],
  1330. v1Avg: 512.1499921798707,
  1331. v2Avg: 177.21062736511232
  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. 514.4686961174011,
  1360. 499.1900291442871,
  1361. 497.70259189605713,
  1362. 518.3011870384216,
  1363. 484.9368486404419
  1364. ],
  1365. v2Results: [
  1366. 241.90118026733398,
  1367. 237.62355995178223,
  1368. 290.8125729560852,
  1369. 236.3748688697815,
  1370. 239.3299126625061
  1371. ],
  1372. v1Avg: 502.91987056732177,
  1373. v2Avg: 249.2084189414978
  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. 799.4153046607971,
  1384. 777.0028653144836,
  1385. 777.2323431968689,
  1386. 785.8897371292114,
  1387. 798.3927230834961
  1388. ],
  1389. v2Results: [
  1390. 311.01856994628906,
  1391. 295.6560649871826,
  1392. 307.79802417755127,
  1393. 305.10088777542114,
  1394. 310.3852291107178
  1395. ],
  1396. v1Avg: 787.5865946769715,
  1397. v2Avg: 305.99175519943236
  1398. }
  1399. {
  1400. v1Query: 'GetBasicVideos',
  1401. v2Query: 'GetBasicVideos',
  1402. v1Input: { where: {}, limit: 1000 },
  1403. v2Input: { where: {}, limit: 1000 },
  1404. v1Rows: 779,
  1405. v2Rows: 779,
  1406. v1Results: [
  1407. 5330.425018787384,
  1408. 5356.049385070801,
  1409. 5433.774178028107,
  1410. 5295.674503803253,
  1411. 5394.812087059021
  1412. ],
  1413. v2Results: [
  1414. 849.0378179550171,
  1415. 836.553328037262,
  1416. 843.9542899131775,
  1417. 825.6594324111938,
  1418. 807.7384171485901
  1419. ],
  1420. v1Avg: 5362.147034549713,
  1421. v2Avg: 832.5886570930481
  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.67720603942871,
  1432. 81.52558422088623,
  1433. 80.4773850440979,
  1434. 80.98601818084717,
  1435. 79.1787657737732
  1436. ],
  1437. v2Results: [
  1438. 100.9360146522522,
  1439. 92.08908939361572,
  1440. 82.77301788330078,
  1441. 98.49220323562622,
  1442. 86.0603346824646
  1443. ],
  1444. v1Avg: 81.56899185180664,
  1445. v2Avg: 92.07013196945191
  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. 82.94252443313599,
  1456. 80.40571403503418,
  1457. 88.00243282318115,
  1458. 81.573157787323,
  1459. 77.25836515426636
  1460. ],
  1461. v2Results: [
  1462. 87.49602127075195,
  1463. 88.36841297149658,
  1464. 90.80904722213745,
  1465. 88.60844612121582,
  1466. 90.22147512435913
  1467. ],
  1468. v1Avg: 82.03643884658814,
  1469. v2Avg: 89.10068054199219
  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. 1032.6302490234375,
  1488. 1029.7906007766724,
  1489. 1072.7440309524536,
  1490. 1031.409644126892,
  1491. 1026.7497262954712
  1492. ],
  1493. v2Results: [
  1494. 336.2768588066101,
  1495. 383.8435468673706,
  1496. 375.41422510147095,
  1497. 396.07827615737915,
  1498. 433.5107431411743
  1499. ],
  1500. v1Avg: 1038.6648502349854,
  1501. v2Avg: 385.02473001480104
  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. 1653.6555547714233,
  1512. 1576.405680179596,
  1513. 1583.077163696289,
  1514. 1790.9930610656738,
  1515. 1519.3924040794373
  1516. ],
  1517. v2Results: [
  1518. 530.14919090271,
  1519. 557.6267728805542,
  1520. 481.2665410041809,
  1521. 527.1358051300049,
  1522. 536.5478067398071
  1523. ],
  1524. v1Avg: 1624.7047727584838,
  1525. v2Avg: 526.5452233314514
  1526. }
  1527. {
  1528. v1Query: 'GetFullVideos',
  1529. v2Query: 'GetFullVideos',
  1530. v1Input: { where: {}, limit: 1000 },
  1531. v2Input: { where: {}, limit: 1000 },
  1532. v1Rows: 779,
  1533. v2Rows: 779,
  1534. v1Results: [
  1535. 11229.611734867096,
  1536. 11183.397915840149,
  1537. 11619.439226150513,
  1538. 11257.4853348732,
  1539. 11296.847748279572
  1540. ],
  1541. v2Results: [
  1542. 1919.4295959472656,
  1543. 2054.9404373168945,
  1544. 2110.6565680503845,
  1545. 1911.7394742965698,
  1546. 1905.1007676124573
  1547. ],
  1548. v1Avg: 11317.356392002106,
  1549. v2Avg: 1980.3733686447144
  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. 78.56457710266113,
  1564. 66.30377721786499,
  1565. 69.91919994354248,
  1566. 71.27927303314209,
  1567. 81.59591484069824
  1568. ],
  1569. v2Results: [
  1570. 644.0295257568359,
  1571. 607.843499660492,
  1572. 658.7308602333069,
  1573. 638.6925640106201,
  1574. 634.631941318512
  1575. ],
  1576. v1Avg: 73.53254842758179,
  1577. v2Avg: 636.7856781959533
  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. 70.81594705581665,
  1601. 71.48780488967896,
  1602. 70.24749755859375,
  1603. 66.39251804351807,
  1604. 65.36716985702515
  1605. ],
  1606. v2Results: [
  1607. 96.57228803634644,
  1608. 92.30346632003784,
  1609. 97.12106513977051,
  1610. 93.89601421356201,
  1611. 102.39606618881226
  1612. ],
  1613. v1Avg: 68.86218748092651,
  1614. v2Avg: 96.4577799797058
  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. 80.6299819946289,
  1638. 67.76058101654053,
  1639. 83.47169589996338,
  1640. 72.06933927536011,
  1641. 75.38465213775635
  1642. ],
  1643. v2Results: [
  1644. 98.32912015914917,
  1645. 99.78071975708008,
  1646. 96.20028257369995,
  1647. 107.51283931732178,
  1648. 92.14394283294678
  1649. ],
  1650. v1Avg: 75.86325006484985,
  1651. v2Avg: 98.79338092803955
  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. 61.79753112792969,
  1671. 68.34893894195557,
  1672. 67.90552186965942,
  1673. 68.42774105072021,
  1674. 68.55544519424438
  1675. ],
  1676. v2Results: [
  1677. 91.75692319869995,
  1678. 86.72869491577148,
  1679. 89.5940899848938,
  1680. 91.78943490982056,
  1681. 87.32158946990967
  1682. ],
  1683. v1Avg: 67.00703563690186,
  1684. v2Avg: 89.4381464958191
  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. 74.12490606307983,
  1704. 66.56605291366577,
  1705. 63.83128118515015,
  1706. 67.35725402832031,
  1707. 63.28269720077515
  1708. ],
  1709. v2Results: [
  1710. 91.50098991394043,
  1711. 90.08909797668457,
  1712. 86.97438192367554,
  1713. 90.94919681549072,
  1714. 84.72011232376099
  1715. ],
  1716. v1Avg: 67.03243827819824,
  1717. v2Avg: 88.84675579071045
  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: 40.43%
  1722. The median of average improvement in query execution time in Orion v2 vs Orion v1 is: 18.66%
  1723. On average, the median improvement in query execution time in Orion v2 vs Orion v1 is: 39.60%
  1724. The median of median improvement in query execution time in Orion v2 vs Orion v1 is: 18.20%
  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: -31.89%
  1728. The median of average improvement in query execution time in Orion v2 vs Orion v1 is: 4.05%
  1729. On average, the median improvement in query execution time in Orion v2 vs Orion v1 is: -32.18%
  1730. The median of median improvement in query execution time in Orion v2 vs Orion v1 is: 3.64%
  1731. ========= QUERIES IN 101ms - 500ms RANGE =========
  1732. Tested queries in this range: 18
  1733. On average, the average improvement in query execution time in Orion v2 vs Orion v1 is: -49.00%
  1734. The median of average improvement in query execution time in Orion v2 vs Orion v1 is: 62.59%
  1735. On average, the median improvement in query execution time in Orion v2 vs Orion v1 is: -48.50%
  1736. The median of median improvement in query execution time in Orion v2 vs Orion v1 is: 61.81%
  1737. ========= QUERIES IN 501ms - 2000ms RANGE =========
  1738. Tested queries in this range: 11
  1739. On average, the average improvement in query execution time in Orion v2 vs Orion v1 is: 103.68%
  1740. The median of average improvement in query execution time in Orion v2 vs Orion v1 is: 157.39%
  1741. On average, the median improvement in query execution time in Orion v2 vs Orion v1 is: 100.30%
  1742. The median of median improvement in query execution time in Orion v2 vs Orion v1 is: 155.33%
  1743. ========= QUERIES IN 2000ms - Infinity RANGE =========
  1744. Tested queries in this range: 8
  1745. On average, the average improvement in query execution time in Orion v2 vs Orion v1 is: 389.77%
  1746. The median of average improvement in query execution time in Orion v2 vs Orion v1 is: 452.53%
  1747. On average, the median improvement in query execution time in Orion v2 vs Orion v1 is: 387.67%
  1748. The median of median improvement in query execution time in Orion v2 vs Orion v1 is: 462.11%