# 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

## Error Summary ?

Description
Some queries have unexpected duration
The test 'count' is too slow to run as a whole. Investigate whether the create and fill queries can be sped up
Some query of the test 'count' is too slow to run. See the all queries report

## Unexpected Query Duration ?

Problem | Marked as "short"? | Run time, s | Test | # | Query
--- | --- | --- | --- | --- | ---
"short" queries must run faster than 0.02 s | 1 | 0.24199999868869781 | count | 0 | SELECT count() FROM data
"short" queries must run faster than 0.02 s | 1 | 0.3880000114440918 | sum | 6 | SELECT sum(x) FROM nullfloat32

## Test Performance Changes ?

Test | Ratio of speedup (-) or slowdown (+) | Queries | Total not OK | Changed perf | Unstable
--- | --- | --- | --- | --- | ---
Total | -1.005x | 9 | 0 | 0 | 0
sum | -1.005x | 7 | 0 | 0 | 0
count | -1.005x | 2 | 0 | 0 | 0

## Test Times ?

Test | Wall clock time, entire test, s | Total client time for measured query runs, s | Queries | Longest query, total for measured runs, s | Wall clock time per query, s | Shortest query, total for measured runs, s
--- | --- | --- | --- | --- | --- | ---
Total | 196.521 | 153.163 | 9 | 85.806 | 21.835 | 4.614
count | 126.949 | 101.844 | 2 | 85.806 | 63.474 | 16.037
sum | 69.571 | 51.318 | 7 | 16.336 | 9.938 | 4.614

All queries Log Test output