Results

Env

• OS: Ubuntu 25.04, 6.14.0-15-generic
• CPU: AMD Ryzen 9 9950X 16-Core Processor
• Disk: NVMe SSD, Samsung SSD 970 EVO Plus 2TB
• rustc: 1.87.0 (17067e9ac 2025-05-09)

Result of writing 10 million records

Synchronous flag is Normal, Journal mode is Wal

Batch size	Unique tag values	Schema type	Average throughput (records/s)	Total time (s)	DB size (MiB)	User time (s)	System time (s)	CPU usage, %
1000	10000	SingleTable	28861.65	346.48	995.32	23.38	85.21	31
1000	20000	SingleTable	28795.79	347.27	992.44	23.79	86.64	31
10000	10000	SingleTable	58417.15	171.18	995.43	19.05	77.54	56
10000	20000	SingleTable	59768.13	167.31	992.29	18.24	76.05	56
1000	10000	MappingAndDataTables	39253.96	254.75	292.54	23.37	51.96	29
1000	20000	MappingAndDataTables	53747.39	186.06	293.11	20.23	37.71	31
10000	10000	MappingAndDataTables	81632.54	122.50	292.55	18.20	48.51	54
10000	20000	MappingAndDataTables	101356.31	98.66	293.11	16.92	37.32	54
1000	10000	Fts5Table	171046.89	58.46	1076.31	37.48	3.54	70
1000	20000	Fts5Table	163331.19	61.23	1106.43	38.73	3.73	69
10000	10000	Fts5Table	205811.06	48.59	1077.44	35.77	3.76	81
10000	20000	Fts5Table	196461.05	50.90	1107.07	36.89	3.97	80

Synchronous flag is Normal, Journal mode is Off

Batch size	Unique tag values	Schema type	Average throughput (records/s)	Total time (s)	DB size (MiB)	User time (s)	System time (s)	CPU usage, %
1000	10000	SingleTable	75362.21	132.69	995.64	11.88	31.58	32
1000	20000	SingleTable	75895.19	131.76	992.37	11.50	32.57	33
10000	10000	SingleTable	146807.83	68.12	995.40	10.53	24.77	51
10000	20000	SingleTable	149614.30	66.84	992.36	10.52	25.16	53
1000	10000	MappingAndDataTables	84796.80	117.93	292.55	16.16	20.54	31
1000	20000	MappingAndDataTables	90203.50	110.86	293.10	16.94	16.28	29
10000	10000	MappingAndDataTables	180956.20	55.26	292.55	13.33	17.44	55
10000	20000	MappingAndDataTables	213010.67	46.95	293.11	12.96	14.10	57
1000	10000	Fts5Table	90917.51	109.99	1077.95	38.97	2.17	37
1000	20000	Fts5Table	89852.41	111.29	1107.38	39.99	2.25	37
10000	10000	Fts5Table	220950.56	45.26	1078.05	35.11	1.55	80
10000	20000	Fts5Table	215136.79	46.48	1107.25	36.06	1.64	80

Synchronous flag is Off, Journal mode is Wal

Batch size	Unique tag values	Schema type	Average throughput (records/s)	Total time (s)	DB size (MiB)	User time (s)	System time (s)	CPU usage, %
1000	10000	SingleTable	140144.09	71.36	995.35	18.16	53.04	99
1000	20000	SingleTable	143098.47	69.88	992.34	17.80	51.95	99
10000	10000	SingleTable	126210.24	79.23	995.02	17.77	61.48	99
10000	20000	SingleTable	128281.28	77.95	992.44	18.02	59.86	99
1000	10000	MappingAndDataTables	218519.27	45.76	292.54	16.70	29.04	99
1000	20000	MappingAndDataTables	260612.07	38.37	293.10	15.89	22.36	99
10000	10000	MappingAndDataTables	184818.32	54.11	292.53	17.45	36.63	99
10000	20000	MappingAndDataTables	225387.20	44.37	293.11	16.11	28.19	99
1000	10000	Fts5Table	252739.21	39.57	1076.05	37.05	2.61	100
1000	20000	Fts5Table	245159.83	40.79	1107.27	38.09	2.80	100
10000	10000	Fts5Table	258948.23	38.62	1078.02	35.42	3.19	99
10000	20000	Fts5Table	251142.90	39.82	1108.68	36.49	3.36	99

Synchronous flag is Off, Journal mode is Off

Batch size	Unique tag values	Schema type	Average throughput (records/s)	Total time (s)	DB size (MiB)	User time (s)	System time (s)	CPU usage, %
1000	10000	SingleTable	420036.20	23.81	995.36	9.70	14.13	99
1000	20000	SingleTable	428771.83	23.32	992.27	9.35	14.03	99
10000	10000	SingleTable	412007.82	24.27	995.39	10.29	13.92	99
10000	20000	SingleTable	414021.99	24.15	992.06	10.25	13.81	99
1000	10000	MappingAndDataTables	458750.11	21.80	292.54	12.78	9.05	100
1000	20000	MappingAndDataTables	499308.00	20.03	293.10	12.82	7.30	100
10000	10000	MappingAndDataTables	445454.66	22.45	292.54	12.98	9.49	100
10000	20000	MappingAndDataTables	484606.05	20.64	293.10	12.82	7.83	99
1000	10000	Fts5Table	266694.04	37.50	1077.70	36.31	1.28	100
1000	20000	Fts5Table	255466.26	39.14	1105.91	37.74	1.38	99
10000	10000	Fts5Table	277570.96	36.03	1077.51	34.82	1.24	99
10000	20000	Fts5Table	266837.96	37.48	1107.73	36.25	1.30	99