Skip to main content

Guandata Platform Performance Test Case

Case

Drill-down operation on tens of millions of rows for a retail customer.

Test Environment Configuration

  • Microsoft Azure virtual cloud host, Cent OS 7.5
  • 8-core CPU, 64 GB memory, single node
  • Intel(R) Xeon(R) CPU E5-2673 v4 @ 2.30GHz

Performance

  • Response time: 7s.
  • The chart below shows the reference result of the performance test.

image.png

As shown, with tens of millions of rows, a single query or aggregation operation can still respond in seconds.

Specifically, performance is related to the actual resource configuration, machine configuration, whether other parallel tasks are running during the query, the complexity of calculated fields, and other factors.

Notes

  • The test above is based on a cloud host, namely a virtual machine. If the actual environment uses physical machines, performance can improve significantly.
  • The test above is a standard test. In actual use, targeted optimization can be performed based on data characteristics and usage scenarios.
  • As the product continues to iterate, performance metrics will continue to improve. Actual performance shall prevail.
  • If needed, contact a solution consultant to perform pre-launch pressure simulation tests, including concurrency tests, and targeted optimization.