Advertisement
Guest User

Experimental Results for TPCH Q1

a guest
Oct 3rd, 2018
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Julia 21.12 KB | None | 0 0
  1. Section 1: Experiments using PagedVectorDict (as internal node impl)
  2.  
  3. Vector
  4. ===========================
  5.  
  6. TPCH Q1: 6NF (and lockstep join) and storing results in an array
  7.   1.974687 seconds (162.25 k allocations: 7.810 MiB)
  8.   0.137221 seconds (18 allocations: 1.688 KiB)
  9.   0.138849 seconds (18 allocations: 1.688 KiB)
  10. TPCH Q1: 6NF (and lockstep join) and storing results in an array and SearchAPI
  11.   0.247057 seconds (165.63 k allocations: 7.848 MiB, 7.39% gc time)
  12.   0.123872 seconds (18 allocations: 1.688 KiB)
  13.   0.125624 seconds (18 allocations: 1.688 KiB)
  14. TPCH Q1: pruned 3NF (not all columns) and storing results in an array
  15.   0.740126 seconds (95.18 k allocations: 4.923 MiB)
  16.   0.068702 seconds (18 allocations: 1.688 KiB)
  17.   0.072615 seconds (18 allocations: 1.688 KiB)
  18. TPCH Q1: pruned 3NF (not all columns) and storing results in an array and SearchAPI
  19.   0.125360 seconds (125.79 k allocations: 6.179 MiB)
  20.   0.053371 seconds (18 allocations: 1.688 KiB)
  21.   0.059172 seconds (18 allocations: 1.688 KiB)
  22. TPCH Q1: 3NF (full table) and storing results in an array
  23.   0.660133 seconds (95.18 k allocations: 4.924 MiB)
  24.   0.134964 seconds (18 allocations: 1.688 KiB)
  25.   0.139606 seconds (18 allocations: 1.688 KiB)
  26. TPCH Q1: 3NF (full table) and storing results in an array and SearchAPI
  27.   0.240219 seconds (125.79 k allocations: 6.179 MiB, 7.68% gc time)
  28.   0.140221 seconds (18 allocations: 1.688 KiB)
  29.   0.146132 seconds (18 allocations: 1.688 KiB)
  30.  
  31. Manual Vector
  32. ===========================
  33.  
  34. TPCH Q1: 6NF (and lockstep join) and storing results in an array
  35.   2.100182 seconds (261.46 k allocations: 11.439 MiB, 0.90% gc time)
  36.   0.139729 seconds (18 allocations: 1.688 KiB)
  37.   0.130722 seconds (18 allocations: 1.688 KiB)
  38. TPCH Q1: 6NF (and lockstep join) and storing results in an array and SearchAPI
  39.   0.285077 seconds (238.72 k allocations: 10.402 MiB)
  40.   0.124071 seconds (18 allocations: 1.688 KiB)
  41.   0.118930 seconds (18 allocations: 1.688 KiB)
  42. TPCH Q1: pruned 3NF (not all columns) and storing results in an array
  43.   0.832871 seconds (122.12 k allocations: 6.029 MiB, 2.90% gc time)
  44.   0.070694 seconds (18 allocations: 1.688 KiB)
  45.   0.073395 seconds (18 allocations: 1.688 KiB)
  46. TPCH Q1: pruned 3NF (not all columns) and storing results in an array and SearchAPI
  47.   0.169120 seconds (148.57 k allocations: 7.036 MiB)
  48.   0.063555 seconds (18 allocations: 1.688 KiB)
  49.   0.068028 seconds (18 allocations: 1.688 KiB)
  50. TPCH Q1: 3NF (full table) and storing results in an array
  51.   2.591615 seconds (145.19 k allocations: 6.877 MiB)
  52.   0.129296 seconds (18 allocations: 1.688 KiB)
  53.   0.132990 seconds (18 allocations: 1.688 KiB)
  54. TPCH Q1: 3NF (full table) and storing results in an array and SearchAPI
  55.   0.232157 seconds (173.81 k allocations: 7.926 MiB, 10.31% gc time)
  56.   0.125705 seconds (18 allocations: 1.688 KiB)
  57.   0.129053 seconds (18 allocations: 1.688 KiB)
  58.  
  59. BeTreeSet (with default node size)
  60. ===========================
  61.  
  62. TPCH Q1: 6NF (and lockstep join) and storing results in an array
  63.   3.152665 seconds (12.42 M allocations: 840.048 MiB, 15.01% gc time)
  64.   0.920118 seconds (12.09 M allocations: 826.719 MiB, 50.12% gc time)
  65.   0.906715 seconds (12.09 M allocations: 826.719 MiB, 49.40% gc time)
  66. TPCH Q1: 6NF (and lockstep join) and storing results in an array and SearchAPI
  67.   0.489331 seconds (329.82 k allocations: 12.802 MiB, 2.76% gc time)
  68.   0.332907 seconds (82.62 k allocations: 2.578 MiB)
  69.   0.351436 seconds (82.62 k allocations: 2.578 MiB)
  70. TPCH Q1: 6NF (and lockstep join) and storing results in an array and SearchAPI and vectorized
  71.   0.564448 seconds (604.48 k allocations: 25.827 MiB, 3.32% gc time)
  72.   0.267920 seconds (82.62 k allocations: 2.578 MiB)
  73.   0.287588 seconds (82.62 k allocations: 2.578 MiB, 7.36% gc time)
  74. TPCH Q1: 6NF (and lockstep join) and storing results in an array and SearchAPI and vectorized (without allocation)
  75.   0.273862 seconds (82.62 k allocations: 2.579 MiB)
  76.   0.281508 seconds (82.62 k allocations: 2.578 MiB)
  77.   0.294340 seconds (82.62 k allocations: 2.578 MiB)
  78. TPCH Q1: pruned 3NF (not all columns) and storing results in an array
  79.   0.905568 seconds (178.61 k allocations: 8.036 MiB)
  80.   0.136234 seconds (11.82 k allocations: 378.563 KiB)
  81.   0.108662 seconds (11.82 k allocations: 378.563 KiB)
  82. TPCH Q1: pruned 3NF (not all columns) and storing results in an array and SearchAPI
  83.   0.220486 seconds (204.67 k allocations: 8.953 MiB, 9.73% gc time)
  84.   0.112222 seconds (11.82 k allocations: 378.734 KiB)
  85.   0.109794 seconds (11.82 k allocations: 378.734 KiB)
  86. TPCH Q1: 3NF (full table) and storing results in an array
  87.   2.585174 seconds (205.44 k allocations: 8.917 MiB)
  88.   0.160202 seconds (11.82 k allocations: 378.563 KiB)
  89.   0.168097 seconds (11.82 k allocations: 378.563 KiB)
  90. TPCH Q1: 3NF (full table) and storing results in an array and SearchAPI
  91.   0.317457 seconds (171.30 k allocations: 7.668 MiB, 6.83% gc time)
  92.   0.164989 seconds (11.82 k allocations: 379.016 KiB)
  93.   0.168097 seconds (11.82 k allocations: 379.016 KiB)
  94.  
  95. BeTree (with a single leaf node)
  96. ===========================
  97.  
  98. TPCH Q1: 6NF (and lockstep join) and storing results in an array
  99.   2.547810 seconds (12.00 M allocations: 824.200 MiB, 17.39% gc time)
  100.   0.864296 seconds (12.00 M allocations: 824.200 MiB, 51.77% gc time)
  101.   0.821365 seconds (12.00 M allocations: 824.200 MiB, 51.83% gc time)
  102. TPCH Q1: 6NF (and lockstep join) and storing results in an array and SearchAPI
  103.   0.282752 seconds (71 allocations: 60.578 KiB)
  104.   0.280518 seconds (71 allocations: 60.578 KiB)
  105.   0.275761 seconds (71 allocations: 60.578 KiB)
  106. TPCH Q1: 6NF (and lockstep join) and storing results in an array and SearchAPI and vectorized
  107.   0.215952 seconds (71 allocations: 60.578 KiB)
  108.   0.211411 seconds (71 allocations: 60.578 KiB)
  109.   0.205477 seconds (71 allocations: 60.578 KiB)
  110. TPCH Q1: 6NF (and lockstep join) and storing results in an array and SearchAPI and vectorized (without allocation)
  111.   0.217671 seconds (72 allocations: 60.609 KiB)
  112.   0.208190 seconds (72 allocations: 60.609 KiB)
  113.   0.210397 seconds (72 allocations: 60.609 KiB)
  114. TPCH Q1: pruned 3NF (not all columns) and storing results in an array
  115.   0.755359 seconds (24 allocations: 10.031 KiB)
  116.   0.092767 seconds (24 allocations: 10.031 KiB)
  117.   0.093145 seconds (24 allocations: 10.031 KiB)
  118. TPCH Q1: pruned 3NF (not all columns) and storing results in an array and SearchAPI
  119.   0.087773 seconds (26 allocations: 10.203 KiB)
  120.   0.091369 seconds (26 allocations: 10.203 KiB)
  121.   0.084745 seconds (26 allocations: 10.203 KiB)
  122. TPCH Q1: 3NF (full table) and storing results in an array
  123.   2.515947 seconds (24 allocations: 10.031 KiB)
  124.   0.146381 seconds (24 allocations: 10.031 KiB)
  125.   0.141373 seconds (24 allocations: 10.031 KiB)
  126. TPCH Q1: 3NF (full table) and storing results in an array and SearchAPI
  127.   0.149147 seconds (26 allocations: 10.484 KiB)
  128.   0.151451 seconds (26 allocations: 10.484 KiB)
  129.   0.159625 seconds (26 allocations: 10.484 KiB)
  130. Main.TpchVariantsBench
  131.  
  132. =====================================================================================
  133. =====================================================================================
  134. =====================================================================================
  135.  
  136. Section 2: Experiments using PagedVectorDict (as internal node impl) + only iterating over values in 6NF
  137.  
  138. Vector
  139. ===========================
  140.  
  141. TPCH Q1: 6NF (and lockstep join) and storing results in an array
  142.   1.984159 seconds (162.25 k allocations: 7.810 MiB)
  143.   0.149014 seconds (18 allocations: 1.688 KiB)
  144.   0.144665 seconds (18 allocations: 1.688 KiB)
  145. TPCH Q1: 6NF (and lockstep join) and storing results in an array and SearchAPI
  146.   0.213364 seconds (165.63 k allocations: 7.848 MiB)
  147.   0.128610 seconds (18 allocations: 1.688 KiB)
  148.   0.122756 seconds (18 allocations: 1.688 KiB)
  149. TPCH Q1: pruned 3NF (not all columns) and storing results in an array
  150.   0.838469 seconds (95.18 k allocations: 4.923 MiB, 2.55% gc time)
  151.   0.074006 seconds (18 allocations: 1.688 KiB)
  152.   0.071453 seconds (18 allocations: 1.688 KiB)
  153. TPCH Q1: pruned 3NF (not all columns) and storing results in an array and SearchAPI
  154.   0.120404 seconds (125.80 k allocations: 6.180 MiB)
  155.   0.057798 seconds (18 allocations: 1.688 KiB)
  156.   0.052640 seconds (18 allocations: 1.688 KiB)
  157. TPCH Q1: 3NF (full table) and storing results in an array
  158.   2.210184 seconds (95.18 k allocations: 4.924 MiB)
  159.   0.155982 seconds (18 allocations: 1.688 KiB)
  160.   0.149450 seconds (18 allocations: 1.688 KiB)
  161. TPCH Q1: 3NF (full table) and storing results in an array and SearchAPI
  162.   0.223263 seconds (125.79 k allocations: 6.179 MiB)
  163.   0.151454 seconds (18 allocations: 1.688 KiB)
  164.   0.154799 seconds (18 allocations: 1.688 KiB)
  165.  
  166. Manual Vector
  167. ===========================
  168.  
  169. TPCH Q1: 6NF (and lockstep join) and storing results in an array
  170.   5.299511 seconds (261.46 k allocations: 11.439 MiB, 0.44% gc time)
  171.   0.142071 seconds (18 allocations: 1.688 KiB)
  172.   0.132944 seconds (18 allocations: 1.688 KiB)
  173. TPCH Q1: 6NF (and lockstep join) and storing results in an array and SearchAPI
  174.   0.238972 seconds (238.72 k allocations: 10.402 MiB)
  175.   0.128364 seconds (18 allocations: 1.688 KiB)
  176.   0.127165 seconds (18 allocations: 1.688 KiB)
  177. TPCH Q1: pruned 3NF (not all columns) and storing results in an array
  178.   2.882454 seconds (122.12 k allocations: 6.029 MiB)
  179.   0.078666 seconds (18 allocations: 1.688 KiB)
  180.   0.073267 seconds (18 allocations: 1.688 KiB)
  181. TPCH Q1: pruned 3NF (not all columns) and storing results in an array and SearchAPI
  182.   0.189573 seconds (148.57 k allocations: 7.036 MiB, 14.75% gc time)
  183.   0.064027 seconds (18 allocations: 1.688 KiB)
  184.   0.061963 seconds (18 allocations: 1.688 KiB)
  185. TPCH Q1: 3NF (full table) and storing results in an array
  186.   9.386651 seconds (145.19 k allocations: 6.877 MiB)
  187.   0.153517 seconds (18 allocations: 1.688 KiB)
  188.   0.141373 seconds (18 allocations: 1.688 KiB)
  189. TPCH Q1: 3NF (full table) and storing results in an array and SearchAPI
  190.   0.246999 seconds (173.81 k allocations: 7.926 MiB)
  191.   0.198151 seconds (18 allocations: 1.688 KiB)
  192.   0.135444 seconds (18 allocations: 1.688 KiB)
  193.  
  194. BeTreeSet (with default node size)
  195. ===========================
  196.  
  197. TPCH Q1: 6NF (and lockstep join) and storing results in an array
  198.   3.236400 seconds (12.42 M allocations: 840.048 MiB, 16.62% gc time)
  199.   0.973164 seconds (12.09 M allocations: 826.719 MiB, 48.91% gc time)
  200.   0.942733 seconds (12.09 M allocations: 826.719 MiB, 48.23% gc time)
  201. TPCH Q1: 6NF (and lockstep join) and storing results in an array and SearchAPI
  202.   0.486291 seconds (329.82 k allocations: 12.802 MiB, 2.73% gc time)
  203.   0.359508 seconds (82.62 k allocations: 2.578 MiB)
  204.   0.365540 seconds (82.62 k allocations: 2.578 MiB)
  205. TPCH Q1: 6NF (and lockstep join) and storing results in an array and SearchAPI and vectorized
  206.   2.001077 seconds (627.91 k allocations: 26.921 MiB, 1.26% gc time)
  207.   0.362335 seconds (82.62 k allocations: 2.578 MiB, 6.43% gc time)
  208.   0.331360 seconds (82.62 k allocations: 2.578 MiB)
  209. TPCH Q1: 6NF (and lockstep join) and storing results in an array and SearchAPI and vectorized (without allocation)
  210.   0.319467 seconds (82.62 k allocations: 2.578 MiB)
  211.   0.326784 seconds (82.62 k allocations: 2.578 MiB)
  212.   0.332368 seconds (82.62 k allocations: 2.578 MiB)
  213. TPCH Q1: pruned 3NF (not all columns) and storing results in an array
  214.   0.922818 seconds (178.61 k allocations: 8.036 MiB)
  215.   0.104459 seconds (11.82 k allocations: 378.563 KiB)
  216.   0.099651 seconds (11.82 k allocations: 378.563 KiB)
  217. TPCH Q1: pruned 3NF (not all columns) and storing results in an array and SearchAPI
  218.   0.233596 seconds (204.67 k allocations: 8.952 MiB, 6.82% gc time)
  219.   0.097053 seconds (11.82 k allocations: 378.734 KiB)
  220.   0.098790 seconds (11.82 k allocations: 378.734 KiB)
  221. TPCH Q1: 3NF (full table) and storing results in an array
  222.   2.705571 seconds (205.44 k allocations: 8.917 MiB)
  223.   0.162816 seconds (11.82 k allocations: 378.563 KiB)
  224.   0.163941 seconds (11.82 k allocations: 378.563 KiB)
  225. TPCH Q1: 3NF (full table) and storing results in an array and SearchAPI
  226.   0.299330 seconds (171.30 k allocations: 7.668 MiB, 7.25% gc time)
  227.   0.161962 seconds (11.82 k allocations: 379.016 KiB)
  228.   0.160492 seconds (11.82 k allocations: 379.016 KiB)
  229.  
  230. BeTree (with a single leaf node)
  231. ===========================
  232.  
  233. TPCH Q1: 6NF (and lockstep join) and storing results in an array
  234.   2.541329 seconds (12.00 M allocations: 824.200 MiB, 18.97% gc time)
  235.   0.947345 seconds (12.00 M allocations: 824.200 MiB, 51.89% gc time)
  236.   0.911718 seconds (12.00 M allocations: 824.200 MiB, 51.55% gc time)
  237. TPCH Q1: 6NF (and lockstep join) and storing results in an array and SearchAPI
  238.   0.285409 seconds (71 allocations: 60.578 KiB)
  239.   0.273179 seconds (71 allocations: 60.578 KiB)
  240.   0.278636 seconds (71 allocations: 60.578 KiB)
  241. TPCH Q1: 6NF (and lockstep join) and storing results in an array and SearchAPI and vectorized
  242.   0.771442 seconds (68 allocations: 60.484 KiB)
  243.   0.250212 seconds (68 allocations: 60.484 KiB)
  244.   0.264830 seconds (68 allocations: 60.484 KiB)
  245. TPCH Q1: 6NF (and lockstep join) and storing results in an array and SearchAPI and vectorized (without allocation)
  246.   0.265520 seconds (69 allocations: 60.516 KiB)
  247.   0.270904 seconds (69 allocations: 60.516 KiB)
  248.   0.261245 seconds (69 allocations: 60.516 KiB)
  249. TPCH Q1: pruned 3NF (not all columns) and storing results in an array
  250.   0.812358 seconds (24 allocations: 10.031 KiB)
  251.   0.093011 seconds (24 allocations: 10.031 KiB)
  252.   0.093799 seconds (24 allocations: 10.031 KiB)
  253. TPCH Q1: pruned 3NF (not all columns) and storing results in an array and SearchAPI
  254.   0.097955 seconds (26 allocations: 10.203 KiB)
  255.   0.093885 seconds (26 allocations: 10.203 KiB)
  256.   0.102665 seconds (26 allocations: 10.203 KiB)
  257. TPCH Q1: 3NF (full table) and storing results in an array
  258.   2.980613 seconds (24 allocations: 10.031 KiB)
  259.   0.172970 seconds (24 allocations: 10.031 KiB)
  260.   0.151856 seconds (24 allocations: 10.031 KiB)
  261. TPCH Q1: 3NF (full table) and storing results in an array and SearchAPI
  262.   0.154636 seconds (26 allocations: 10.484 KiB)
  263.   0.156837 seconds (26 allocations: 10.484 KiB)
  264.   0.146306 seconds (26 allocations: 10.484 KiB)
  265. Main.TpchVariantsBench
  266.  
  267. =====================================================================================
  268. =====================================================================================
  269. =====================================================================================
  270.  
  271. Section 3: Experiments using NaivePackedMemoryArray (as internal node impl) + only iterating over values in 6NF
  272.  
  273. Vector
  274. ===========================
  275.  
  276. TPCH Q1: 6NF (and lockstep join) and storing results in an array
  277.   3.694407 seconds (162.25 k allocations: 7.810 MiB)
  278.   0.139563 seconds (18 allocations: 1.688 KiB)
  279.   0.134977 seconds (18 allocations: 1.688 KiB)
  280. TPCH Q1: 6NF (and lockstep join) and storing results in an array and SearchAPI
  281.   0.258373 seconds (165.63 k allocations: 7.848 MiB, 8.93% gc time)
  282.   0.126238 seconds (18 allocations: 1.688 KiB)
  283.   0.120480 seconds (18 allocations: 1.688 KiB)
  284. TPCH Q1: pruned 3NF (not all columns) and storing results in an array
  285.   0.580151 seconds (95.18 k allocations: 4.923 MiB)
  286.   0.071117 seconds (18 allocations: 1.688 KiB)
  287.   0.070751 seconds (18 allocations: 1.688 KiB)
  288. TPCH Q1: pruned 3NF (not all columns) and storing results in an array and SearchAPI
  289.   0.265644 seconds (125.80 k allocations: 6.180 MiB)
  290.   0.057653 seconds (18 allocations: 1.688 KiB)
  291.   0.056456 seconds (18 allocations: 1.688 KiB)
  292. TPCH Q1: 3NF (full table) and storing results in an array
  293.   0.384087 seconds (95.18 k allocations: 4.924 MiB, 6.59% gc time)
  294.   0.145853 seconds (18 allocations: 1.688 KiB)
  295.   0.149505 seconds (18 allocations: 1.688 KiB)
  296. TPCH Q1: 3NF (full table) and storing results in an array and SearchAPI
  297.   0.328709 seconds (125.79 k allocations: 6.179 MiB)
  298.   0.151520 seconds (18 allocations: 1.688 KiB)
  299.   0.154308 seconds (18 allocations: 1.688 KiB)
  300.  
  301. Manual Vector
  302. ===========================
  303.  
  304. TPCH Q1: 6NF (and lockstep join) and storing results in an array
  305.   6.080816 seconds (261.46 k allocations: 11.439 MiB, 0.38% gc time)
  306.   0.132988 seconds (18 allocations: 1.688 KiB)
  307.   0.141533 seconds (18 allocations: 1.688 KiB)
  308. TPCH Q1: 6NF (and lockstep join) and storing results in an array and SearchAPI
  309.   0.290223 seconds (238.72 k allocations: 10.402 MiB)
  310.   0.123992 seconds (18 allocations: 1.688 KiB)
  311.   0.127511 seconds (18 allocations: 1.688 KiB)
  312. TPCH Q1: pruned 3NF (not all columns) and storing results in an array
  313.   3.113549 seconds (122.12 k allocations: 6.029 MiB, 0.92% gc time)
  314.   0.075526 seconds (18 allocations: 1.688 KiB)
  315.   0.067480 seconds (18 allocations: 1.688 KiB)
  316. TPCH Q1: pruned 3NF (not all columns) and storing results in an array and SearchAPI
  317.   0.302643 seconds (148.57 k allocations: 7.036 MiB)
  318.   0.063505 seconds (18 allocations: 1.688 KiB)
  319.   0.062111 seconds (18 allocations: 1.688 KiB)
  320. TPCH Q1: 3NF (full table) and storing results in an array
  321.   8.625361 seconds (145.19 k allocations: 6.877 MiB)
  322.   0.134744 seconds (18 allocations: 1.688 KiB)
  323.   0.137532 seconds (18 allocations: 1.688 KiB)
  324. TPCH Q1: 3NF (full table) and storing results in an array and SearchAPI
  325.   0.479518 seconds (173.81 k allocations: 7.926 MiB, 4.72% gc time)
  326.   0.131151 seconds (18 allocations: 1.688 KiB)
  327.   0.131064 seconds (18 allocations: 1.688 KiB)
  328.  
  329. BeTreeSet (with default node size)
  330. ===========================
  331.  
  332. TPCH Q1: 6NF (and lockstep join) and storing results in an array
  333.  13.130949 seconds (12.18 M allocations: 831.455 MiB, 4.11% gc time)
  334.   1.173827 seconds (12.09 M allocations: 826.730 MiB, 46.52% gc time)
  335.   1.329728 seconds (12.09 M allocations: 826.730 MiB, 45.81% gc time)
  336. TPCH Q1: 6NF (and lockstep join) and storing results in an array and SearchAPI
  337.   0.562158 seconds (205.93 k allocations: 8.639 MiB, 2.88% gc time)
  338.   0.411197 seconds (82.97 k allocations: 2.589 MiB)
  339.   0.483628 seconds (82.97 k allocations: 2.589 MiB)
  340. TPCH Q1: 6NF (and lockstep join) and storing results in an array and SearchAPI and vectorized
  341.   5.561607 seconds (890.17 k allocations: 35.678 MiB, 0.91% gc time)
  342.   0.441433 seconds (82.96 k allocations: 2.589 MiB)
  343.   0.449831 seconds (82.96 k allocations: 2.589 MiB)
  344. TPCH Q1: 6NF (and lockstep join) and storing results in an array and SearchAPI and vectorized (without allocation)
  345.   0.450140 seconds (82.96 k allocations: 2.589 MiB)
  346.   0.455808 seconds (82.96 k allocations: 2.589 MiB)
  347.   0.442662 seconds (82.96 k allocations: 2.589 MiB)
  348. TPCH Q1: pruned 3NF (not all columns) and storing results in an array
  349.   2.818402 seconds (252.61 k allocations: 10.633 MiB, 0.83% gc time)
  350.   0.129413 seconds (11.87 k allocations: 380.094 KiB)
  351.   0.125111 seconds (11.87 k allocations: 380.094 KiB)
  352. TPCH Q1: pruned 3NF (not all columns) and storing results in an array and SearchAPI
  353.   0.277008 seconds (189.97 k allocations: 8.361 MiB)
  354.   0.115165 seconds (11.87 k allocations: 380.266 KiB)
  355.   0.110194 seconds (11.87 k allocations: 380.266 KiB)
  356. TPCH Q1: 3NF (full table) and storing results in an array
  357.   5.605764 seconds (281.64 k allocations: 11.543 MiB, 0.51% gc time)
  358.   0.178826 seconds (11.87 k allocations: 380.094 KiB)
  359.   0.163082 seconds (11.87 k allocations: 380.094 KiB)
  360. TPCH Q1: 3NF (full table) and storing results in an array and SearchAPI
  361.   0.371190 seconds (206.09 k allocations: 8.867 MiB)
  362.   0.235044 seconds (11.87 k allocations: 380.547 KiB)
  363.   0.222041 seconds (11.87 k allocations: 380.547 KiB)
  364.  
  365. BeTree (with a single leaf node)
  366. ===========================
  367.  
  368. TPCH Q1: 6NF (and lockstep join) and storing results in an array
  369.   3.668092 seconds (12.00 M allocations: 824.200 MiB, 14.28% gc time)
  370.   0.971284 seconds (12.00 M allocations: 824.200 MiB, 49.00% gc time)
  371.   1.005749 seconds (12.00 M allocations: 824.200 MiB, 47.43% gc time)
  372. TPCH Q1: 6NF (and lockstep join) and storing results in an array and SearchAPI
  373.   0.384855 seconds (71 allocations: 60.578 KiB)
  374.   0.396531 seconds (71 allocations: 60.578 KiB)
  375.   0.376085 seconds (71 allocations: 60.578 KiB)
  376. TPCH Q1: 6NF (and lockstep join) and storing results in an array and SearchAPI and vectorized
  377.   1.390636 seconds (68 allocations: 60.484 KiB)
  378.   0.402572 seconds (68 allocations: 60.484 KiB)
  379.   0.413713 seconds (68 allocations: 60.484 KiB)
  380. TPCH Q1: 6NF (and lockstep join) and storing results in an array and SearchAPI and vectorized (without allocation)
  381.   0.406413 seconds (69 allocations: 60.516 KiB)
  382.   0.397642 seconds (69 allocations: 60.516 KiB)
  383.   0.418506 seconds (69 allocations: 60.516 KiB)
  384. TPCH Q1: pruned 3NF (not all columns) and storing results in an array
  385.   1.046233 seconds (24 allocations: 10.031 KiB)
  386.   0.104058 seconds (24 allocations: 10.031 KiB)
  387.   0.099305 seconds (24 allocations: 10.031 KiB)
  388. TPCH Q1: pruned 3NF (not all columns) and storing results in an array and SearchAPI
  389.   0.096887 seconds (26 allocations: 10.203 KiB)
  390.   0.096939 seconds (26 allocations: 10.203 KiB)
  391.   0.097576 seconds (26 allocations: 10.203 KiB)
  392. TPCH Q1: 3NF (full table) and storing results in an array
  393.   3.273430 seconds (24 allocations: 10.031 KiB)
  394.   0.186621 seconds (24 allocations: 10.031 KiB)
  395.   0.192003 seconds (24 allocations: 10.031 KiB)
  396. TPCH Q1: 3NF (full table) and storing results in an array and SearchAPI
  397.   0.214559 seconds (26 allocations: 10.484 KiB)
  398.   0.199411 seconds (26 allocations: 10.484 KiB)
  399.   0.191825 seconds (26 allocations: 10.484 KiB)
  400. Main.TpchVariantsBench
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement