benchmark_result_without_events 36 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584
  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. 351.02572298049927,
  12. 144.37370491027832,
  13. 114.2889461517334,
  14. 99.33062028884888,
  15. 111.39957427978516
  16. ],
  17. v2Results: [
  18. 256.1857099533081,
  19. 73.308021068573,
  20. 67.76437997817993,
  21. 71.22424077987671,
  22. 70.45703315734863
  23. ],
  24. v1Avg: 164.083713722229,
  25. v2Avg: 107.78787698745728
  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.72837686538696,
  36. 86.81660032272339,
  37. 83.32580709457397,
  38. 80.82108688354492,
  39. 79.33098030090332
  40. ],
  41. v2Results: [
  42. 65.52863597869873,
  43. 65.38411617279053,
  44. 64.07430124282837,
  45. 66.65355920791626,
  46. 66.97036504745483
  47. ],
  48. v1Avg: 84.20457029342651,
  49. v2Avg: 65.72219552993775
  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. 291.56118297576904,
  60. 271.3921489715576,
  61. 318.485634803772,
  62. 276.305832862854,
  63. 249.57571029663086
  64. ],
  65. v2Results: [
  66. 135.63745975494385,
  67. 136.04301595687866,
  68. 122.84854412078857,
  69. 131.01009893417358,
  70. 126.48750591278076
  71. ],
  72. v1Avg: 281.4641019821167,
  73. v2Avg: 130.4053249359131
  74. }
  75. {
  76. v1Query: 'GetVideoCategories',
  77. v2Query: 'GetExtendedVideoCategories',
  78. v1Input: undefined,
  79. v2Input: undefined,
  80. v1Rows: 29,
  81. v2Rows: 29,
  82. v1Results: [
  83. 64.07827997207642,
  84. 61.663715839385986,
  85. 56.17241191864014,
  86. 61.84263372421265,
  87. 64.47818899154663
  88. ],
  89. v2Results: [
  90. 76.97072887420654,
  91. 67.68674516677856,
  92. 59.853971004486084,
  93. 59.00072908401489,
  94. 62.8611741065979
  95. ],
  96. v1Avg: 61.64704608917236,
  97. v2Avg: 65.2746696472168
  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. 78.6821231842041,
  108. 67.4102578163147,
  109. 65.54518222808838,
  110. 73.16770267486572,
  111. 71.42301797866821
  112. ],
  113. v2Results: [
  114. 63.20758819580078,
  115. 55.80344772338867,
  116. 58.91524600982666,
  117. 60.20719003677368,
  118. 62.53057813644409
  119. ],
  120. v1Avg: 71.24565677642822,
  121. v2Avg: 60.132810020446776
  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. 76.57626628875732,
  132. 69.95659112930298,
  133. 67.14319515228271,
  134. 74.0327959060669,
  135. 62.68935489654541
  136. ],
  137. v2Results: [
  138. 66.42495203018188,
  139. 63.51208972930908,
  140. 63.843608379364014,
  141. 60.161314964294434,
  142. 60.84304666519165
  143. ],
  144. v1Avg: 70.07964067459106,
  145. v2Avg: 62.957002353668216
  146. }
  147. {
  148. v1Query: 'GetVideoCount',
  149. v2Query: 'GetVideoCount',
  150. v1Input: { where: {} },
  151. v2Input: { where: {} },
  152. v1Rows: 1,
  153. v2Rows: 1,
  154. v1Results: [
  155. 59.42924880981445,
  156. 61.186224937438965,
  157. 68.07916116714478,
  158. 62.48158884048462,
  159. 62.887285232543945
  160. ],
  161. v2Results: [
  162. 59.52981185913086,
  163. 59.4633731842041,
  164. 56.996686935424805,
  165. 60.65805530548096,
  166. 59.71352291107178
  167. ],
  168. v1Avg: 62.81270179748535,
  169. v2Avg: 59.2722900390625
  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. 161.2904977798462,
  188. 140.99450397491455,
  189. 130.2878041267395,
  190. 129.56940031051636,
  191. 136.74770975112915
  192. ],
  193. v2Results: [
  194. 72.40646409988403,
  195. 79.6157751083374,
  196. 73.38055276870728,
  197. 71.08998489379883,
  198. 73.57665014266968
  199. ],
  200. v1Avg: 139.77798318862915,
  201. v2Avg: 74.01388540267945
  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. 171.06009769439697,
  212. 204.85531616210938,
  213. 216.27013492584229,
  214. 217.25743579864502,
  215. 215.53982400894165
  216. ],
  217. v2Results: [
  218. 210.8510389328003,
  219. 179.29413318634033,
  220. 187.0370101928711,
  221. 182.00229740142822,
  222. 187.68624687194824
  223. ],
  224. v1Avg: 204.99656171798705,
  225. v2Avg: 189.37414531707765
  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. 1184.7927551269531,
  236. 1057.7540402412415,
  237. 1054.7816181182861,
  238. 1074.3552598953247,
  239. 1013.4511742591858
  240. ],
  241. v2Results: [
  242. 473.5260920524597,
  243. 481.73468017578125,
  244. 472.5509309768677,
  245. 466.19573879241943,
  246. 460.4130778312683
  247. ],
  248. v1Avg: 1077.0269695281982,
  249. v2Avg: 470.88410396575927
  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. 207.08776473999023,
  260. 190.1620111465454,
  261. 198.29216814041138,
  262. 196.66253900527954,
  263. 197.91717290878296
  264. ],
  265. v2Results: [
  266. 137.15320587158203,
  267. 130.24438619613647,
  268. 143.06694793701172,
  269. 129.45653820037842,
  270. 129.90967798233032
  271. ],
  272. v1Avg: 198.0243311882019,
  273. v2Avg: 133.9661512374878
  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. 479.3956027030945,
  284. 474.2727789878845,
  285. 503.69446420669556,
  286. 487.54080533981323,
  287. 485.7384366989136
  288. ],
  289. v2Results: [
  290. 321.03546380996704,
  291. 301.72580003738403,
  292. 300.6019039154053,
  293. 306.901074886322,
  294. 313.21841287612915
  295. ],
  296. v1Avg: 486.1284175872803,
  297. v2Avg: 308.6965311050415
  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. 3703.879601955414,
  308. 3625.786853790283,
  309. 3549.6904430389404,
  310. 3761.639130115509,
  311. 3533.107913017273
  312. ],
  313. v2Results: [
  314. 727.8321404457092,
  315. 737.2137570381165,
  316. 679.8065857887268,
  317. 689.4157419204712,
  318. 740.1408367156982
  319. ],
  320. v1Avg: 3634.820788383484,
  321. v2Avg: 714.8818123817443
  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. 222.8079390525818,
  338. 165.16188669204712,
  339. 172.60509395599365,
  340. 163.67632293701172,
  341. 164.14750719070435
  342. ],
  343. v2Results: [
  344. 83.96283292770386,
  345. 80.49282264709473,
  346. 86.18280601501465,
  347. 77.42142486572266,
  348. 75.00189018249512
  349. ],
  350. v1Avg: 177.67974996566772,
  351. v2Avg: 80.6123553276062
  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. 60.209189891815186,
  362. 68.78154993057251,
  363. 63.43837213516235,
  364. 56.839077949523926,
  365. 63.86671686172485
  366. ],
  367. v2Results: [
  368. 63.91867113113403,
  369. 68.12056970596313,
  370. 61.683133125305176,
  371. 62.352580070495605,
  372. 67.7284049987793
  373. ],
  374. v1Avg: 62.62698135375977,
  375. v2Avg: 64.76067180633545
  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. 115.12865495681763,
  386. 124.91708183288574,
  387. 115.0407133102417,
  388. 113.2903470993042,
  389. 115.83485221862793
  390. ],
  391. v2Results: [
  392. 64.88032913208008,
  393. 66.88290309906006,
  394. 66.79583215713501,
  395. 72.32754755020142,
  396. 66.61921834945679
  397. ],
  398. v1Avg: 116.84232988357545,
  399. v2Avg: 67.50116605758667
  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. 107.86486339569092,
  410. 117.13844203948975,
  411. 117.69694375991821,
  412. 122.36654615402222,
  413. 115.51811408996582
  414. ],
  415. v2Results: [
  416. 71.5183572769165,
  417. 67.6355357170105,
  418. 66.71591567993164,
  419. 66.3922610282898,
  420. 70.23603439331055
  421. ],
  422. v1Avg: 116.11698188781739,
  423. v2Avg: 68.4996208190918
  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. 60.22153329849243,
  434. 61.00160217285156,
  435. 62.18603515625,
  436. 65.1305022239685,
  437. 60.20593881607056
  438. ],
  439. v2Results: [
  440. 64.07989692687988,
  441. 65.53806591033936,
  442. 70.62896966934204,
  443. 65.83584213256836,
  444. 63.14526987075806
  445. ],
  446. v1Avg: 61.749122333526614,
  447. v2Avg: 65.84560890197754
  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. 84.721999168396,
  458. 84.92406034469604,
  459. 73.64917755126953,
  460. 77.56458187103271,
  461. 73.21150493621826
  462. ],
  463. v2Results: [
  464. 71.46470785140991,
  465. 68.61239719390869,
  466. 61.16129684448242,
  467. 60.24693298339844,
  468. 62.460777282714844
  469. ],
  470. v1Avg: 78.81426477432251,
  471. v2Avg: 64.78922243118286
  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. 67.84387969970703,
  482. 63.071584701538086,
  483. 62.56364679336548,
  484. 57.57170867919922,
  485. 62.76511573791504
  486. ],
  487. v2Results: [
  488. 65.34497594833374,
  489. 58.24398183822632,
  490. 60.57919502258301,
  491. 57.718688011169434,
  492. 67.62197971343994
  493. ],
  494. v1Avg: 62.76318712234497,
  495. v2Avg: 61.90176410675049
  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. 72.73540163040161,
  514. 68.1835708618164,
  515. 69.02516984939575,
  516. 74.44636821746826,
  517. 67.76200008392334
  518. ],
  519. v2Results: [
  520. 64.69666004180908,
  521. 61.359211921691895,
  522. 61.207284927368164,
  523. 56.96854114532471,
  524. 56.10349798202515
  525. ],
  526. v1Avg: 70.43050212860108,
  527. v2Avg: 60.0670392036438
  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.10666704177856,
  548. 99.75271797180176,
  549. 97.94096612930298,
  550. 97.9159369468689,
  551. 102.24518013000488
  552. ],
  553. v2Results: [
  554. 78.03773307800293,
  555. 80.50903797149658,
  556. 74.89095067977905,
  557. 89.05176115036011,
  558. 74.12760162353516
  559. ],
  560. v1Avg: 99.79229364395141,
  561. v2Avg: 79.32341690063477
  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. 69.01059103012085,
  572. 60.79531908035278,
  573. 62.57866716384888,
  574. 64.36368608474731,
  575. 61.62317514419556
  576. ],
  577. v2Results: [
  578. 60.38915300369263,
  579. 61.218173027038574,
  580. 57.35211515426636,
  581. 54.18977403640747,
  582. 57.046114921569824
  583. ],
  584. v1Avg: 63.674287700653075,
  585. v2Avg: 58.03906602859497
  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. 74.94028902053833,
  596. 64.4493670463562,
  597. 61.975950717926025,
  598. 71.22682285308838,
  599. 77.15701866149902
  600. ],
  601. v2Results: [
  602. 63.545719146728516,
  603. 67.16982984542847,
  604. 66.6722583770752,
  605. 67.7824273109436,
  606. 70.37388181686401
  607. ],
  608. v1Avg: 69.94988965988159,
  609. v2Avg: 67.10882329940796
  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.47532320022583,
  634. 64.83420991897583,
  635. 64.44350290298462,
  636. 71.51928424835205,
  637. 63.933963775634766
  638. ],
  639. v2Results: [
  640. 66.49474000930786,
  641. 55.089118003845215,
  642. 55.08620309829712,
  643. 54.01557207107544,
  644. 55.725101947784424
  645. ],
  646. v1Avg: 67.64125680923462,
  647. v2Avg: 57.28214702606201
  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. 75.24080801010132,
  686. 69.42366790771484,
  687. 71.78870296478271,
  688. 73.58966827392578,
  689. 70.84509086608887
  690. ],
  691. v2Results: [
  692. 64.64723205566406,
  693. 62.55567407608032,
  694. 55.5822548866272,
  695. 59.06649971008301,
  696. 60.49521780014038
  697. ],
  698. v1Avg: 72.1775876045227,
  699. v2Avg: 60.469375705718996
  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.9235978126526,
  740. 126.7927598953247,
  741. 118.37580299377441,
  742. 125.27902221679688,
  743. 136.18229484558105
  744. ],
  745. v2Results: [
  746. 81.64089584350586,
  747. 68.00131559371948,
  748. 113.7443299293518,
  749. 68.08289098739624,
  750. 70.67308521270752
  751. ],
  752. v1Avg: 127.31069555282593,
  753. v2Avg: 80.42850351333618
  754. }
  755. {
  756. v1Query: 'GetAllCategoriesFeaturedVideos',
  757. v2Query: 'GetAllCategoriesFeaturedVideos',
  758. v1Input: undefined,
  759. v2Input: undefined,
  760. v1Rows: 0,
  761. v2Rows: 0,
  762. v1Results: [
  763. 69.29430913925171,
  764. 57.667731285095215,
  765. 57.642905712127686,
  766. 56.32417678833008,
  767. 60.51044178009033
  768. ],
  769. v2Results: [
  770. 87.38526105880737,
  771. 82.61059713363647,
  772. 91.014732837677,
  773. 81.35418796539307,
  774. 83.27819108963013
  775. ],
  776. v1Avg: 60.287912940979005,
  777. v2Avg: 85.1285940170288
  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. 192.48236513137817,
  788. 173.80783700942993,
  789. 181.8291220664978,
  790. 180.28931283950806,
  791. 181.42369174957275
  792. ],
  793. v2Results: [
  794. 67.34213590621948,
  795. 66.56249284744263,
  796. 66.09216594696045,
  797. 64.94986724853516,
  798. 73.94656705856323
  799. ],
  800. v1Avg: 181.96646575927736,
  801. v2Avg: 67.77864580154419
  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. 345.690495967865,
  812. 314.55832529067993,
  813. 320.7412452697754,
  814. 325.7995090484619,
  815. 316.1946539878845
  816. ],
  817. v2Results: [
  818. 127.85859060287476,
  819. 121.17460203170776,
  820. 132.59450387954712,
  821. 130.5676770210266,
  822. 135.50622701644897
  823. ],
  824. v1Avg: 324.59684591293336,
  825. v2Avg: 129.54032011032103
  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. 31217.29212999344,
  836. 31195.989154815674,
  837. 31005.00260591507,
  838. 31196.03697490692,
  839. 31175.859553337097
  840. ],
  841. v2Results: [
  842. 3316.195736885071,
  843. 3648.7722063064575,
  844. 3655.7634172439575,
  845. 3413.6556582450867,
  846. 3371.402070045471
  847. ],
  848. v1Avg: 31158.03608379364,
  849. v2Avg: 3481.157817745209
  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. 92.38447523117065,
  860. 80.11186408996582,
  861. 78.84967994689941,
  862. 85.38935804367065,
  863. 87.2223629951477
  864. ],
  865. v2Results: [
  866. 120.59908199310303,
  867. 98.16303014755249,
  868. 95.06198167800903,
  869. 97.07886791229248,
  870. 99.6321153640747
  871. ],
  872. v1Avg: 84.79154806137085,
  873. v2Avg: 102.10701541900634
  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.61159420013428,
  884. 84.14678287506104,
  885. 74.11174583435059,
  886. 81.91703128814697,
  887. 82.16833686828613
  888. ],
  889. v2Results: [
  890. 93.37670469284058,
  891. 93.64284086227417,
  892. 108.13537120819092,
  893. 98.7408390045166,
  894. 91.6027340888977
  895. ],
  896. v1Avg: 81.3910982131958,
  897. v2Avg: 97.099697971344
  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. 1537.781542301178,
  908. 1454.5448899269104,
  909. 1418.5338640213013,
  910. 1393.5445580482483,
  911. 1416.2222032546997
  912. ],
  913. v2Results: [
  914. 464.40286779403687,
  915. 460.86845111846924,
  916. 437.1583843231201,
  917. 430.3762011528015,
  918. 448.22832202911377
  919. ],
  920. v1Avg: 1444.1254115104675,
  921. v2Avg: 448.2068452835083
  922. }
  923. {
  924. v1Query: 'GetNfts',
  925. v2Query: 'GetNfts',
  926. v1Input: { where: {}, limit: 1000 },
  927. v2Input: { where: {}, limit: 1000 },
  928. v1Rows: 631,
  929. v2Rows: 631,
  930. v1Results: [
  931. 8648.370851039886,
  932. 8032.49658203125,
  933. 8294.345482349396,
  934. 8178.65115070343,
  935. 8034.094361782074
  936. ],
  937. v2Results: [
  938. 1209.1400990486145,
  939. 1073.0909543037415,
  940. 1054.402156829834,
  941. 1021.5400218963623,
  942. 1042.990526676178
  943. ],
  944. v1Avg: 8237.591685581207,
  945. v2Avg: 1080.2327517509461
  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. 224.2797532081604,
  960. 188.783203125,
  961. 188.66390466690063,
  962. 198.7700653076172,
  963. 200.44619178771973
  964. ],
  965. v2Results: [
  966. 194.62058401107788,
  967. 182.8341908454895,
  968. 190.04347276687622,
  969. 202.23474502563477,
  970. 238.03395175933838
  971. ],
  972. v1Avg: 200.18862361907958,
  973. v2Avg: 201.55338888168336
  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. 839.4913139343262,
  988. 858.2606058120728,
  989. 826.8806748390198,
  990. 891.1690502166748,
  991. 830.2530360221863
  992. ],
  993. v2Results: [
  994. 323.97558784484863,
  995. 316.07275199890137,
  996. 372.93453311920166,
  997. 350.01811504364014,
  998. 323.0510182380676
  999. ],
  1000. v1Avg: 849.210936164856,
  1001. v2Avg: 337.2104012489319
  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. 811.175449848175,
  1012. 848.1425633430481,
  1013. 802.7815489768982,
  1014. 815.3897981643677,
  1015. 787.5873188972473
  1016. ],
  1017. v2Results: [
  1018. 459.72402906417847,
  1019. 431.54463624954224,
  1020. 420.48580598831177,
  1021. 428.74516105651855,
  1022. 433.21308994293213
  1023. ],
  1024. v1Avg: 813.0153358459472,
  1025. v2Avg: 434.74254446029664
  1026. }
  1027. {
  1028. v1Query: 'GetDistributionBucketsWithBags',
  1029. v2Query: 'GetDistributionBucketsWithBags',
  1030. v1Input: undefined,
  1031. v2Input: undefined,
  1032. v1Rows: 16,
  1033. v2Rows: 16,
  1034. v1Results: [
  1035. 5883.147616863251,
  1036. 6437.796696186066,
  1037. 5931.157866001129,
  1038. 6185.892535209656,
  1039. 6127.641261577606
  1040. ],
  1041. v2Results: [
  1042. 2414.379853248596,
  1043. 2340.5169496536255,
  1044. 2282.6629910469055,
  1045. 2437.533754825592,
  1046. 2545.099416255951
  1047. ],
  1048. v1Avg: 6113.127195167542,
  1049. v2Avg: 2404.038593006134
  1050. }
  1051. {
  1052. v1Query: 'GetStorageBucketsWithBags',
  1053. v2Query: 'GetStorageBucketsWithBags',
  1054. v1Input: undefined,
  1055. v2Input: undefined,
  1056. v1Rows: 5,
  1057. v2Rows: 5,
  1058. v1Results: [
  1059. 5038.884709358215,
  1060. 5607.376286029816,
  1061. 4975.983366012573,
  1062. 5149.292353630066,
  1063. 5210.415150165558
  1064. ],
  1065. v2Results: [
  1066. 1680.396508693695,
  1067. 1732.5695571899414,
  1068. 1726.2483820915222,
  1069. 1809.3679809570312,
  1070. 1745.495244026184
  1071. ],
  1072. v1Avg: 5196.390373039246,
  1073. v2Avg: 1738.8155345916748
  1074. }
  1075. {
  1076. v1Query: 'GetBasicDistributionBuckets',
  1077. v2Query: 'GetBasicDistributionBuckets',
  1078. v1Input: undefined,
  1079. v2Input: undefined,
  1080. v1Rows: 6,
  1081. v2Rows: 6,
  1082. v1Results: [
  1083. 74.92073488235474,
  1084. 70.62652254104614,
  1085. 63.20944309234619,
  1086. 65.37120485305786,
  1087. 65.35340213775635
  1088. ],
  1089. v2Results: [
  1090. 52.08699178695679,
  1091. 49.34480857849121,
  1092. 53.62740993499756,
  1093. 56.36330604553223,
  1094. 58.073333740234375
  1095. ],
  1096. v1Avg: 67.89626150131225,
  1097. v2Avg: 53.89917001724243
  1098. }
  1099. {
  1100. v1Query: 'GetBasicStorageBuckets',
  1101. v2Query: 'GetBasicStorageBuckets',
  1102. v1Input: undefined,
  1103. v2Input: undefined,
  1104. v1Rows: 5,
  1105. v2Rows: 5,
  1106. v1Results: [
  1107. 55.010536670684814,
  1108. 63.92977285385132,
  1109. 58.74574518203735,
  1110. 61.03099536895752,
  1111. 61.72537803649902
  1112. ],
  1113. v2Results: [
  1114. 58.75134611129761,
  1115. 56.61147117614746,
  1116. 56.69510316848755,
  1117. 55.04124689102173,
  1118. 55.93437910079956
  1119. ],
  1120. v1Avg: 60.088485622406004,
  1121. v2Avg: 56.60670928955078
  1122. }
  1123. {
  1124. v1Query: 'GetBasicVideosConnection',
  1125. v2Query: 'GetBasicVideosConnection',
  1126. v1Input: {
  1127. where: {
  1128. isPublic_eq: true,
  1129. thumbnailPhoto: [Object],
  1130. media: [Object],
  1131. title_contains: 'a'
  1132. },
  1133. first: 50,
  1134. orderBy: [ 'reactionsCount_DESC', 'commentsCount_DESC', 'createdAt_DESC' ]
  1135. },
  1136. v2Input: {
  1137. where: {
  1138. isPublic_eq: true,
  1139. thumbnailPhoto: [Object],
  1140. media: [Object],
  1141. title_contains: 'a'
  1142. },
  1143. first: 50,
  1144. orderBy: [ 'reactionsCount_DESC', 'commentsCount_DESC', 'createdAt_DESC' ]
  1145. },
  1146. v1Rows: 50,
  1147. v2Rows: 50,
  1148. v1Results: [
  1149. 572.0018677711487,
  1150. 482.29221057891846,
  1151. 514.3223552703857,
  1152. 504.5605368614197,
  1153. 535.0036463737488
  1154. ],
  1155. v2Results: [
  1156. 133.4855670928955,
  1157. 132.24152898788452,
  1158. 193.72595596313477,
  1159. 183.37153577804565,
  1160. 212.65218687057495
  1161. ],
  1162. v1Avg: 521.6361233711243,
  1163. v2Avg: 171.09535493850709
  1164. }
  1165. {
  1166. v1Query: 'GetBasicVideosConnection',
  1167. v2Query: 'GetBasicVideosConnection',
  1168. v1Input: {
  1169. where: {
  1170. isPublic_eq: true,
  1171. thumbnailPhoto: [Object],
  1172. media: [Object],
  1173. channel: [Object]
  1174. },
  1175. first: 50,
  1176. orderBy: 'createdAt_DESC'
  1177. },
  1178. v2Input: {
  1179. where: {
  1180. isPublic_eq: true,
  1181. thumbnailPhoto: [Object],
  1182. media: [Object],
  1183. channel: [Object]
  1184. },
  1185. first: 50,
  1186. orderBy: 'createdAt_DESC'
  1187. },
  1188. v1Rows: 50,
  1189. v2Rows: 50,
  1190. v1Results: [
  1191. 516.7374062538147,
  1192. 493.71704721450806,
  1193. 472.7464499473572,
  1194. 487.26635789871216,
  1195. 516.6283240318298
  1196. ],
  1197. v2Results: [
  1198. 237.61371326446533,
  1199. 239.8506259918213,
  1200. 236.74835586547852,
  1201. 240.24665117263794,
  1202. 236.99432182312012
  1203. ],
  1204. v1Avg: 497.4191170692444,
  1205. v2Avg: 238.29073362350465
  1206. }
  1207. {
  1208. v1Query: 'GetBasicVideos',
  1209. v2Query: 'GetBasicVideos',
  1210. v1Input: { where: {}, limit: 100 },
  1211. v2Input: { where: {}, limit: 100 },
  1212. v1Rows: 100,
  1213. v2Rows: 100,
  1214. v1Results: [
  1215. 819.8700528144836,
  1216. 775.5232028961182,
  1217. 795.8243880271912,
  1218. 829.5806188583374,
  1219. 813.335364818573
  1220. ],
  1221. v2Results: [
  1222. 305.6489977836609,
  1223. 292.4465560913086,
  1224. 319.4423804283142,
  1225. 278.46905994415283,
  1226. 304.03416681289673
  1227. ],
  1228. v1Avg: 806.8267254829407,
  1229. v2Avg: 300.0082322120667
  1230. }
  1231. {
  1232. v1Query: 'GetBasicVideos',
  1233. v2Query: 'GetBasicVideos',
  1234. v1Input: { where: {}, limit: 1000 },
  1235. v2Input: { where: {}, limit: 1000 },
  1236. v1Rows: 778,
  1237. v2Rows: 778,
  1238. v1Results: [
  1239. 5388.0146317481995,
  1240. 5546.750940799713,
  1241. 5421.953876018524,
  1242. 5200.1736850738525,
  1243. 5526.722643852234
  1244. ],
  1245. v2Results: [
  1246. 787.4114141464233,
  1247. 839.0167841911316,
  1248. 879.9918007850647,
  1249. 843.1927008628845,
  1250. 792.5112299919128
  1251. ],
  1252. v1Avg: 5416.723155498505,
  1253. v2Avg: 828.4247859954834
  1254. }
  1255. {
  1256. v1Query: 'GetFullVideo',
  1257. v2Query: 'GetFullVideo',
  1258. v1Input: { where: { id: '5' } },
  1259. v2Input: { id: '5' },
  1260. v1Rows: 1,
  1261. v2Rows: 1,
  1262. v1Results: [
  1263. 92.01959896087646,
  1264. 82.05976486206055,
  1265. 84.47138786315918,
  1266. 73.0777940750122,
  1267. 78.35286712646484
  1268. ],
  1269. v2Results: [
  1270. 94.91889429092407,
  1271. 93.26108932495117,
  1272. 85.57831907272339,
  1273. 85.97363090515137,
  1274. 86.60453271865845
  1275. ],
  1276. v1Avg: 81.99628257751465,
  1277. v2Avg: 89.26729326248169
  1278. }
  1279. {
  1280. v1Query: 'GetFullVideo',
  1281. v2Query: 'GetFullVideo',
  1282. v1Input: { where: { id: '338' } },
  1283. v2Input: { id: '338' },
  1284. v1Rows: 1,
  1285. v2Rows: 1,
  1286. v1Results: [
  1287. 84.5684289932251,
  1288. 85.39738082885742,
  1289. 83.32421064376831,
  1290. 85.44851398468018,
  1291. 84.29686880111694
  1292. ],
  1293. v2Results: [
  1294. 99.19255018234253,
  1295. 84.94116306304932,
  1296. 78.35830593109131,
  1297. 89.33116674423218,
  1298. 94.41657495498657
  1299. ],
  1300. v1Avg: 84.60708065032959,
  1301. v2Avg: 89.24795217514038
  1302. }
  1303. {
  1304. v1Query: 'GetFullVideosConnection',
  1305. v2Query: 'GetFullVideosConnection',
  1306. v1Input: {
  1307. first: 50,
  1308. orderBy: 'createdAt_DESC',
  1309. where: { channel: [Object] }
  1310. },
  1311. v2Input: {
  1312. first: 50,
  1313. orderBy: 'createdAt_DESC',
  1314. where: { channel: [Object] }
  1315. },
  1316. v1Rows: 50,
  1317. v2Rows: 50,
  1318. v1Results: [
  1319. 1084.4443321228027,
  1320. 1038.4766573905945,
  1321. 1016.0386118888855,
  1322. 1019.0978503227234,
  1323. 1147.4668412208557
  1324. ],
  1325. v2Results: [
  1326. 352.9328670501709,
  1327. 419.7729182243347,
  1328. 408.9530391693115,
  1329. 395.9355549812317,
  1330. 396.96132707595825
  1331. ],
  1332. v1Avg: 1061.1048585891724,
  1333. v2Avg: 394.9111413002014
  1334. }
  1335. {
  1336. v1Query: 'GetFullVideos',
  1337. v2Query: 'GetFullVideos',
  1338. v1Input: { where: {}, limit: 100 },
  1339. v2Input: { where: {}, limit: 100 },
  1340. v1Rows: 100,
  1341. v2Rows: 100,
  1342. v1Results: [
  1343. 1573.3234586715698,
  1344. 1593.4580950737,
  1345. 1499.2919759750366,
  1346. 1575.9014353752136,
  1347. 1568.499349117279
  1348. ],
  1349. v2Results: [
  1350. 520.0619840621948,
  1351. 521.4182653427124,
  1352. 522.97691822052,
  1353. 528.3123297691345,
  1354. 514.3947477340698
  1355. ],
  1356. v1Avg: 1562.09486284256,
  1357. v2Avg: 521.4328490257263
  1358. }
  1359. {
  1360. v1Query: 'GetFullVideos',
  1361. v2Query: 'GetFullVideos',
  1362. v1Input: { where: {}, limit: 1000 },
  1363. v2Input: { where: {}, limit: 1000 },
  1364. v1Rows: 778,
  1365. v2Rows: 778,
  1366. v1Results: [
  1367. 11669.284381866455,
  1368. 11160.417222976685,
  1369. 11350.557770729065,
  1370. 11605.046117782593,
  1371. 11425.330091953278
  1372. ],
  1373. v2Results: [
  1374. 1907.529704093933,
  1375. 1944.6552982330322,
  1376. 1932.0102367401123,
  1377. 1958.9019808769226,
  1378. 1994.9127740859985
  1379. ],
  1380. v1Avg: 11442.127117061615,
  1381. v2Avg: 1947.6019988059998
  1382. }
  1383. {
  1384. v1Query: 'GetMetaprotocolTransactionStatusEvents',
  1385. v2Query: 'GetMetaprotocolTransactionStatusEvents',
  1386. v1Input: {
  1387. transactionHash: '0x536d93a5e19c48d6f5983c8de3b9622fe44d096f13698aa2c13e8ae0f8a62780'
  1388. },
  1389. v2Input: {
  1390. transactionHash: '0x536d93a5e19c48d6f5983c8de3b9622fe44d096f13698aa2c13e8ae0f8a62780'
  1391. },
  1392. v1Rows: 1,
  1393. v2Rows: 1,
  1394. v1Results: [
  1395. 85.6957688331604,
  1396. 64.56345510482788,
  1397. 61.467331886291504,
  1398. 75.40327310562134,
  1399. 62.78186321258545
  1400. ],
  1401. v2Results: [
  1402. 633.5990433692932,
  1403. 625.4406132698059,
  1404. 613.8682188987732,
  1405. 644.7749752998352,
  1406. 629.5833640098572
  1407. ],
  1408. v1Avg: 69.98233842849731,
  1409. v2Avg: 629.453242969513
  1410. }
  1411. {
  1412. v1Query: 'GetMostViewedVideosConnection',
  1413. v2Query: 'GetMostViewedVideosConnection',
  1414. v1Input: {
  1415. periodDays: 30,
  1416. orderBy: 'createdAt_DESC',
  1417. where: { isPublic_eq: true, thumbnailPhoto: [Object], media: [Object] }
  1418. },
  1419. v2Input: {
  1420. periodDays: 30,
  1421. orderBy: 'createdAt_DESC',
  1422. where: {
  1423. isPublic_eq: true,
  1424. thumbnailPhoto: [Object],
  1425. media: [Object],
  1426. viewsNum_gt: 0
  1427. }
  1428. },
  1429. v1Rows: 0,
  1430. v2Rows: 0,
  1431. v1Results: [
  1432. 76.2688422203064,
  1433. 74.14687538146973,
  1434. 69.02205419540405,
  1435. 68.34701442718506,
  1436. 66.85932207107544
  1437. ],
  1438. v2Results: [
  1439. 114.99944591522217,
  1440. 107.10354280471802,
  1441. 104.1666431427002,
  1442. 96.21369075775146,
  1443. 98.52290534973145
  1444. ],
  1445. v1Avg: 70.92882165908813,
  1446. v2Avg: 104.20124559402466
  1447. }
  1448. {
  1449. v1Query: 'GetMostViewedVideosConnection',
  1450. v2Query: 'GetMostViewedVideosConnection',
  1451. v1Input: {
  1452. periodDays: 7,
  1453. orderBy: 'createdAt_DESC',
  1454. where: { isPublic_eq: true, thumbnailPhoto: [Object], media: [Object] }
  1455. },
  1456. v2Input: {
  1457. periodDays: 7,
  1458. orderBy: 'createdAt_DESC',
  1459. where: {
  1460. isPublic_eq: true,
  1461. thumbnailPhoto: [Object],
  1462. media: [Object],
  1463. viewsNum_gt: 0
  1464. }
  1465. },
  1466. v1Rows: 0,
  1467. v2Rows: 0,
  1468. v1Results: [
  1469. 74.28222703933716,
  1470. 67.32513999938965,
  1471. 72.52995491027832,
  1472. 62.718424797058105,
  1473. 68.46848821640015
  1474. ],
  1475. v2Results: [
  1476. 98.96771430969238,
  1477. 98.3171501159668,
  1478. 95.49901390075684,
  1479. 107.23607587814331,
  1480. 92.00734186172485
  1481. ],
  1482. v1Avg: 69.06484699249268,
  1483. v2Avg: 98.40545921325683
  1484. }
  1485. {
  1486. v1Query: 'GetTop10VideosThisMonth',
  1487. v2Query: 'GetTop10VideosThisMonth',
  1488. v1Input: {
  1489. where: { isPublic_eq: true, thumbnailPhoto: [Object], media: [Object] }
  1490. },
  1491. v2Input: {
  1492. where: {
  1493. isPublic_eq: true,
  1494. thumbnailPhoto: [Object],
  1495. media: [Object],
  1496. viewsNum_gt: 0
  1497. }
  1498. },
  1499. v1Rows: 0,
  1500. v2Rows: 0,
  1501. v1Results: [
  1502. 65.34620904922485,
  1503. 65.79404592514038,
  1504. 67.71387100219727,
  1505. 67.69756174087524,
  1506. 55.415831089019775
  1507. ],
  1508. v2Results: [
  1509. 94.46654272079468,
  1510. 86.30305910110474,
  1511. 88.43129587173462,
  1512. 95.22284030914307,
  1513. 83.87975120544434
  1514. ],
  1515. v1Avg: 64.3935037612915,
  1516. v2Avg: 89.66069784164429
  1517. }
  1518. {
  1519. v1Query: 'GetTop10VideosThisWeek',
  1520. v2Query: 'GetTop10VideosThisWeek',
  1521. v1Input: {
  1522. where: { isPublic_eq: true, thumbnailPhoto: [Object], media: [Object] }
  1523. },
  1524. v2Input: {
  1525. where: {
  1526. isPublic_eq: true,
  1527. thumbnailPhoto: [Object],
  1528. media: [Object],
  1529. viewsNum_gt: 0
  1530. }
  1531. },
  1532. v1Rows: 0,
  1533. v2Rows: 0,
  1534. v1Results: [
  1535. 62.04579496383667,
  1536. 67.56130504608154,
  1537. 75.61498928070068,
  1538. 57.82266092300415,
  1539. 65.20413017272949
  1540. ],
  1541. v2Results: [
  1542. 85.8071141242981,
  1543. 91.32144403457642,
  1544. 107.3624529838562,
  1545. 82.71107578277588,
  1546. 83.85615825653076
  1547. ],
  1548. v1Avg: 65.6497760772705,
  1549. v2Avg: 90.21164903640747
  1550. }
  1551. ========= QUERIES IN 0ms - Infinity RANGE =========
  1552. Tested queries in this range: 56
  1553. On average, the average improvement in query execution time in Orion v2 vs Orion v1 is: 86.57%
  1554. The median of average improvement in query execution time in Orion v2 vs Orion v1 is: 27.05%
  1555. On average, the median improvement in query execution time in Orion v2 vs Orion v1 is: 85.59%
  1556. The median of median improvement in query execution time in Orion v2 vs Orion v1 is: 27.49%
  1557. ========= QUERIES IN 0ms - 100ms RANGE =========
  1558. Tested queries in this range: 27
  1559. On average, the average improvement in query execution time in Orion v2 vs Orion v1 is: -31.97%
  1560. The median of average improvement in query execution time in Orion v2 vs Orion v1 is: 1.39%
  1561. On average, the median improvement in query execution time in Orion v2 vs Orion v1 is: -34.06%
  1562. The median of median improvement in query execution time in Orion v2 vs Orion v1 is: 3.61%
  1563. ========= QUERIES IN 101ms - 500ms RANGE =========
  1564. Tested queries in this range: 14
  1565. On average, the average improvement in query execution time in Orion v2 vs Orion v1 is: 79.92%
  1566. The median of average improvement in query execution time in Orion v2 vs Orion v1 is: 71.31%
  1567. On average, the median improvement in query execution time in Orion v2 vs Orion v1 is: 81.53%
  1568. The median of median improvement in query execution time in Orion v2 vs Orion v1 is: 76.30%
  1569. ========= QUERIES IN 501ms - 2000ms RANGE =========
  1570. Tested queries in this range: 8
  1571. On average, the average improvement in query execution time in Orion v2 vs Orion v1 is: 166.48%
  1572. The median of average improvement in query execution time in Orion v2 vs Orion v1 is: 168.81%
  1573. On average, the median improvement in query execution time in Orion v2 vs Orion v1 is: 162.34%
  1574. The median of median improvement in query execution time in Orion v2 vs Orion v1 is: 164.56%
  1575. ========= QUERIES IN 2000ms - Infinity RANGE =========
  1576. Tested queries in this range: 7
  1577. On average, the average improvement in query execution time in Orion v2 vs Orion v1 is: 465.79%
  1578. The median of average improvement in query execution time in Orion v2 vs Orion v1 is: 487.50%
  1579. On average, the median improvement in query execution time in Orion v2 vs Orion v1 is: 467.49%
  1580. The median of median improvement in query execution time in Orion v2 vs Orion v1 is: 487.52%