HappenLee commented on pull request #3666:
URL: https://github.com/apache/incubator-doris/pull/3666#issuecomment-632982262
@chaoyli
OKļ¼This is performance result.
### ENV
CPU : Intel(R) Xeon(R) CPU E5-2620 v2 @ 2.10GHz 6cores * 2
RAM : 96GB
### Data
Random numbers from 1 to 50 million
### Test Result
Order of arrangement | origin | find_the_median | Percentage increase
:--:|:--:|:--:|:--:
Order | 41s985ms | 39s389ms | 6.18%
Reverse | 36s854ms | 34s376ms | 6.67%
Random Shuffle |36s520ms | 33s888ms | 7.2%
Now Doris's optimizer is not powerful enough. I test the scenario where the
order by column cardinality is small and the repetition rate is high. If we
can Intelligently choose three way quick sort, there will be five to ten times
better performance. What a pity.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
