NYC Test Performance

Overview

With MatrixOne v0.2.0, we follow the Tutorial to execute NYC Taxi test with a standalone server, and compare the results with that of other products, which shows the performance of MatrixOne in query processing time.

note

The following test results are the average of the three tests in seconds.

Standalone node

Info

The following server was used: AMD EPYC™ Rome CPU 2.6GHz/3.3GHz, 16 physical cores total, 32 GiB Memory.

Query IDMatrixOne 0.2.0ClickHouse v21.11.4.14Starrocks v1.19.3
(Only 30M unique data)
Q18.375.992.58
Q22.674.132.18
Q33.484.563.43
Q45.347.094.19
SUM19.8621.7712.38

柱状图

Limitations

There are some limitations on quiries in MatrixOne v0.2.0:

  • The filter command WHERE is not surpported
  • The table cannot be partitioned currently, so commands as PARTITION series are not surpported

Learn More

This page shows the results of NYC Test with MatrixOne. For information on other benchmarks that are available when trying out MatrixOne, see the following: