SonicBase. In-memory embedded or distributed streaming sql database

Batch Insert Benchmark

In this benchmark we add person records and membership records to the database in batches on a 4, 8, 16 and 32 server cluster.

Metric 4-Server 8-Server 16-Server 32-Server
Record size 120 bytes 120 bytes 120 bytes 120 bytes
Record count 750 million 1.5 billion 3 billion 6 billion
Batch Size 500 500 500 500
Server total mem 60g 60g 60g 60g
Server xmx 36g 36g 36g 36g
Resident mem 52g 52g 52g 52g
Client machine count 8 16 32 64
Cores per client machine 4 4 4 4
Cores per server machine 8 8 8 8
Call rate 720k/sec 1.32 mil/sec 2.5 mil/sec 5.2 mil/sec
Call latency 90 micros 93 micros 112 micros 118 micros
Threads per client 8 8 8 8
Shard Count 4 8 16 32
Replica Count 1 1 1 1