Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[performance] comparison with ClickHouse latest version #1129

Closed
BohuTANG opened this issue Jul 21, 2021 · 1 comment
Closed

[performance] comparison with ClickHouse latest version #1129

BohuTANG opened this issue Jul 21, 2021 · 1 comment
Labels
C-performance Category: Performance

Comments

@BohuTANG
Copy link
Member

Summary

... ...

Alexey Milovidov, [21.07.21 07:34]
Great! BTW, last night I tried to reproduce performance tests from your repository. I found that first queries are indeed faster in Datafuse (due to compilation for native instruction set) but the latest queries - the only queries with ORDER BY or GROUP BY are multiple times faster in ClickHouse. I've tested on Intel and AMD machines in AWS.

I can send you logs to update the results.

BohuTANG, [21.07.21 07:35]
Thanks. I will check it again

Alexey Milovidov, [21.07.21 07:36]
[ File : datafuse_log_intel.txt ]

Alexey Milovidov, [21.07.21 07:36]
[ File : datafuse_log_amd.txt ]

Alexey Milovidov, [21.07.21 07:37]
AMD machine is c5a.8xlarge.
Intel machine - don't remember, something like c5.8xlarge or similar.

BohuTANG, [21.07.21 07:38]
I will try the latest version ClickHouse
@sundy-li
Copy link
Member

sundy-li commented Aug 13, 2021

cc @alexey-milovidov

Hello, I just noticed this issue had been created 23 days ago since the last time you contact BohuTANG.
We are still busy developing the next alpha version, so we almost forgot to track the benchmarks with the latest version.

As you said, the store in datafuse is not ready, the benchmark with inconsistent conditions will be a little bit unfair and unfriendly, we will never do that again.

But if you still want to see the comparison between the latest versions of both, we'd like to send a text to you in private.

Best wishes.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
C-performance Category: Performance
Projects
None yet
Development

No branches or pull requests

2 participants