Skip to content

SSB Test Performance

Overview

We present the SSB Test results for MatrixOne with different hardwares and query modes.

For instructions to reproduce the SSB test results listed here, see SSB Test with MatrixOne, and if you fail to achieve similar results, there is likely a problem in either the hardware, workload, or test design.

In v0.2.0, both single table and multiple tables can work in MatrixOne, and we compared results of MatrixOne with other similar database products. Through the clear comparison of the bar chart, you will see that MatrixOne has an obvious advantage in the query processing time.

Recommended server specification: x86 CPU with 16 cores and 64GB memory, with CentOS 7+ OS.

note

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

In order to show the single-table query performance, we combine five tables into a flat table called lineorder_flat.

Standalone node&Single table

We use standalone service to execute flat table(lineorder_flat) queries with MatrixOne, and compared the results with ClickHouse in the same configuration.
The table lineorder_flat has 600 million rows data and takes up 220 GB of space.

Info

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

Query ID MatrixOne v0.2.0 ClickHouse v21.11.4.14
Q2 2.71 3.82
Q3.1 4.23 5.01
Q3.2 11.05 21.34
Q4.1 2.94 3.1
Q4.2 4.27 5.32
Q4.3 16.91 26.32
SUM 42.11 64.91

柱状图

Standalone node&Multiple tables

With a standalone server again, now we execute multiple tables queries on the original tables of SSB Test.
There are 600 million rows of data in all, and the main table takes up 67 GB of space.

Query ID MatrixOne v0.2.0 ClickHouse v21.11.4.14 Starrocks v1.19.3
Q2 13.6 28.05 15.83
Q3.1 12.94 27.81 16.98
Q3.2 23.56 54.84 29.25
Q4.1 13.96 27.2 16.77
Q4.2 19.72 41.82 21.54
Q4.3 46.07 85.99 35.95
SUM 129.85 265.71 136.37

柱状图

Cluster&Multiple tables

There are three nodes in the cluster, each of which is installed as standalone version, and process time is shorter than that of standclone node, demonstrating the overall performance will improve as the number of nodes increases.

Query ID MatrixOne v0.2.0 Starrocks v1.19.3
Q2 4.94 6.08
Q3.1 5.85 6.27
Q3.2 9.67 9.79
Q4.1 6.05 6.87
Q4.2 6.87 9.51
Q4.3 20.1 15.55
SUM 53.48 54.07

柱状图

Limitations

We didn't finished all the quiries of SSB Test in MatrixOne v0.2.0 because:

  • 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 SSB Test with MatrixOne. For information on other benchmarks that are available when trying out MatrixOne, see the following: