DEV Community

tongxi
tongxi

Posted on

openGauss MOT Data Ingestion Speed

This test simulates realtime data streams arriving from massive IoT, cloud or mobile devices that need to be quickly and continuously ingested into the database on a massive scale.

The test involved ingesting large quantities of data, as follows –

10 million rows were sent by 500 threads, 2000 rounds, 10 records (rows) in each insert command, each record was 200 bytes.
The client and database were on different machines. Database server – x86 2-socket, 72 cores.
Performance Results

Throughput – 10,000 Records/Core or 2 MB/Core.
Latency – 2.8ms per a 10 records bulk insert (includes client-server networking)
CAUTION: We are projecting that multiple additional, and even significant, performance improvements will be made by MOT for this scenario. Click MOT Usage Scenariosfor more information about large-scale data streaming and data ingestion.

Top comments (0)