# apache doris performance comparison

## Tested Commits ?

Old | New
--- | ---
    commit 4f6d13a765cbc39e47194521febf999ac29f0de5 (HEAD, origin/master, origin/HEAD, master, compile)
    Merge: 743ea69 8207883
    Author: dataroaring <98214048+dataroaring@users.noreply.github.com>
    Date:   Sun Feb 6 15:12:24 2022 +0800

        Merge branch 'apache:master' into master
    Real tested commit is:
    commit 4f6d13a765cbc39e47194521febf999ac29f0de5 (HEAD, origin/master, pr, master)
    Merge: 743ea69 8207883
    Author: dataroaring <98214048+dataroaring@users.noreply.github.com>
    Date:   Sun Feb 6 15:12:24 2022 +0800

        Merge branch 'apache:master' into master

## All Query Times ?

Old, s | New, s | Ratio of speedup (-) or slowdown (+) | Relative difference (new − old) / old | p < 0.01 threshold | Test | # | Query
--- | --- | --- | --- | --- | --- | --- | ---
0.241 | 0.242 | +1.002x | 0.002 | 0.020 | count | 0 | SELECT count() FROM data
6.129 | 6.050 | -1.013x | -0.013 | 0.024 | count | 1 | SELECT count(k) FROM (SELECT k FROM data, numbers_20 _a) as _b
0.323 | 0.329 | +1.017x | 0.017 | 0.026 | sum | 0 | SELECT sum(number) FROM numbers_10000000
0.429 | 0.436 | +1.014x | 0.014 | 0.027 | sum | 1 | SELECT sum(CAST(number AS INT)) FROM numbers_10000000
0.441 | 0.426 | -1.035x | -0.034 | 0.055 | sum | 2 | SELECT sum(CAST(number AS SMALLINT)) FROM numbers_10000000
0.429 | 0.433 | +1.009x | 0.009 | 0.047 | sum | 3 | SELECT sum(CAST(number AS TINYINT)) FROM numbers_10000000
0.458 | 0.440 | -1.041x | -0.040 | 0.041 | sum | 4 | SELECT sum(CAST(number AS FLOAT)) FROM numbers_10000000
0.400 | 0.397 | -1.007x | -0.008 | 0.047 | sum | 5 | SELECT sum(CAST(number AS DOUBLE)) FROM numbers_10000000
0.387 | 0.388 | +1.002x | 0.002 | 0.026 | sum | 6 | SELECT sum(x) FROM nullfloat32

Main report Log Test output