Github user cramja commented on the issue:

    https://github.com/apache/incubator-quickstep/pull/109
  
    I ran TPCH 10 on a cloudlab instance. The update is marginally better. Note 
that *master* is using splitrows, not columnstores. Also this is queries `01 04 
06 09 10 11 12 13 14 15 16 19 22`
    
    |master|splitrow refactor| master - splitrow refactor|
    |---|---|---|
    |   2244.56|   2227.01|      17.5|
    |    482.29|    475.22|       7.1|
    |    298.32|    295.05|       3.3|
    |    823.28|    822.34|       0.9|
    |   1655.41|   1680.74|     -25.3|
    |    343.62|    360.24|     -16.6|
    |    566.85|    568.88|      -2.0|
    |   3189.44|   3104.58|      84.9|
    |    315.47|    312.61|       2.9|
    |    594.03|    555.04|      39.0|
    |   1076.28|   1132.68|     -56.4|
    |    448.39|    441.66|       6.7|
    |    776.47|    777.97|      -1.5|
    |  12814   |12754|60.39|
    **Note the last row is a total**
    
    
    Comparing it against *Master* on which uses compressed columnstores, I 
found:
    
    |master_cs|splitrow refactor| master_cs - splitrow refactor|
    |---|---|---|
    |   1676.65|   2227.01|    -550.4|
    |    324.30|    475.22|    -150.9|
    |     44.78|    295.05|    -250.3|
    |    692.21|    822.34|    -130.1|
    |   1522.79|   1680.74|    -158.0|
    |    325.94|    360.24|     -34.3|
    |    210.29|    568.88|    -358.6|
    |   3278.79|   3104.58|     174.2|
    |     98.74|    312.61|    -213.9|
    |    430.47|    555.04|    -124.6|
    |    977.81|   1132.68|    -154.9|
    |    113.18|    441.66|    -328.5|
    |    779.42|    777.97|       1.5|
    |10475.37|12754.02|-2278.64|
    
    **Note the last row is a total**
    
    So apparently compression is the way to go here. Though, this is of course 
still an improvement on the old splitrow.


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

Reply via email to