数据库基准测试报告

测试时间: 2025-12-09 18:24:49

服务器信息

项目	值
机器名称	DESKTOP-RLEON3G
操作系统	Microsoft Windows 10.0.19045
OS 架构	X64
进程架构	X64
处理器数量	24
.NET 版本	.NET 8.0.20
总内存	31.81 GB
采集时间	2025-12-09 18:24:49

测试概要

项目	值
测试数据库	MySQL, SQLServer, PostgreSQL, SQLite, MongoDB
数据库数量	5
总测试用例数	100
成功用例数	100
失败用例数	0
成功率	100.00%

性能对比总览

操作耗时对比 (毫秒 - 越小越好)

操作类型	操作名称	MongoDB	MySQL	PostgreSQL	SQLite	SQLServer	最快
Aggregation	GroupBy	232.50	257.50	38.00	208.00	54.50	PostgreSQL
Aggregation	Statistics	307.50	260.00	191.00	545.50	118.00	SQLServer
Batch	Delete	2967.00	3293.00	1783.50	978.00	25357.00	SQLite
Batch	Insert	3538.00	30198.50	83543.50	37584.00	251540.50	MongoDB
Batch	Select	2983.00	4131.50	1051.50	4429.50	2864.50	PostgreSQL
Batch	Update	15253.50	31195.00	63698.50	35118.00	289606.50	MongoDB
Single	Delete	5818.50	35009.00	8967.00	25420.50	16562.00	MongoDB
Single	Insert	4056.00	35841.50	10261.50	25300.00	15474.00	MongoDB
Single	Select	5457.00	10429.00	3466.00	1654.00	9370.00	SQLite
Single	Update	6056.00	36275.00	12978.50	26186.00	26187.00	MongoDB

每秒操作数对比 (OPS - 越大越好)

操作类型	操作名称	MongoDB	MySQL	PostgreSQL	SQLite	SQLServer	最快
Aggregation	GroupBy	4.30	3.92	26.61	4.81	18.38	PostgreSQL
Aggregation	Statistics	3.25	23.10	32.16	11.00	50.86	SQLServer
Batch	Delete	168708.22	151860.78	281087.47	511255.99	19729.65	SQLite
Batch	Insert	141457.05	16577.72	5985.00	14387.24	1988.18	MongoDB
Batch	Select	167616.57	121022.36	475710.05	125101.46	175800.09	PostgreSQL
Batch	Update	32780.17	16034.28	7871.99	14245.20	1726.88	MongoDB
Single	Delete	1720.20	285.69	1115.24	398.01	605.48	MongoDB
Single	Insert	2469.82	279.02	980.49	398.44	647.27	MongoDB
Single	Select	1832.62	959.21	2885.22	6969.16	1070.01	SQLite
Single	Update	1651.28	275.72	774.10	385.80	382.90	MongoDB

各数据库详细结果

MongoDB

操作类型	操作名称	记录数	耗时(ms)	OPS	CPU(%)	内存增量	状态
Aggregation	GroupBy	8	231	4.33	0.00	32 KB	✅
Aggregation	GroupBy	8	234	4.27	0.00	44 KB	✅
Aggregation	Statistics	500,000	310	3.23	0.21	748 KB	✅
Aggregation	Statistics	500,000	305	3.28	0.00	0 B	✅
Batch	Delete	500,000	2,868	174337.52	0.52	21.63 MB	✅
Batch	Delete	500,000	3,066	163078.93	0.45	19.28 MB	✅
Batch	Insert	500,000	3,647	137098.99	1.52	31.8 MB	✅
Batch	Insert	500,000	3,429	145815.11	1.37	31.6 MB	✅
Batch	Select	500,000	2,985	167504.19	1.57	9.86 MB	✅
Batch	Select	500,000	2,981	167728.95	1.81	0 B	✅
Batch	Update	500,000	15,178	32942.42	1.47	43.94 MB	✅
Batch	Update	500,000	15,329	32617.91	1.47	37.01 MB	✅
Single	Delete	10,000	5,644	1771.79	1.91	7.16 MB	✅
Single	Delete	10,000	5,993	1668.61	1.93	0 B	✅
Single	Insert	10,000	4,226	2366.30	1.63	6.13 MB	✅
Single	Insert	10,000	3,886	2573.34	1.31	3.89 MB	✅
Single	Select	10,000	5,499	1818.51	2.04	892 KB	✅
Single	Select	10,000	5,415	1846.72	2.14	0 B	✅
Single	Update	10,000	6,034	1657.28	2.01	12.07 MB	✅
Single	Update	10,000	6,078	1645.28	2.04	3.78 MB	✅

MySQL

操作类型	操作名称	记录数	耗时(ms)	OPS	CPU(%)	内存增量	状态
Aggregation	GroupBy	8	232	4.31	1.68	1.83 MB	✅
Aggregation	GroupBy	8	283	3.53	0.46	1.02 MB	✅
Aggregation	Statistics	500,000	268	22.39	0.48	2.01 MB	✅
Aggregation	Statistics	500,000	252	23.81	0.00	0 B	✅
Batch	Delete	500,000	3,334	149970.01	0.66	10.74 MB	✅
Batch	Delete	500,000	3,252	153751.54	0.52	7.69 MB	✅
Batch	Insert	500,000	31,263	15993.35	2.23	14.1 MB	✅
Batch	Insert	500,000	29,134	17162.08	2.32	17.07 MB	✅
Batch	Select	500,000	4,120	121359.22	1.49	5.03 MB	✅
Batch	Select	500,000	4,143	120685.49	1.52	12.5 MB	✅
Batch	Update	500,000	30,588	16346.28	2.10	3.01 MB	✅
Batch	Update	500,000	31,802	15722.28	2.02	5.49 MB	✅
Single	Delete	10,000	34,535	289.56	0.51	0 B	✅
Single	Delete	10,000	35,483	281.83	0.53	120 KB	✅
Single	Insert	10,000	35,591	280.97	0.62	2.35 MB	✅
Single	Insert	10,000	36,092	277.07	0.59	0 B	✅
Single	Select	10,000	10,628	940.91	2.03	2.46 MB	✅
Single	Select	10,000	10,230	977.52	1.86	0 B	✅
Single	Update	10,000	35,816	279.20	0.62	11.42 MB	✅
Single	Update	10,000	36,734	272.23	0.56	5.39 MB	✅

PostgreSQL

操作类型	操作名称	记录数	耗时(ms)	OPS	CPU(%)	内存增量	状态
Aggregation	GroupBy	8	42	23.81	0.00	12 KB	✅
Aggregation	GroupBy	8	34	29.41	0.00	304 KB	✅
Aggregation	Statistics	500,000	220	27.27	0.88	848 KB	✅
Aggregation	Statistics	500,000	162	37.04	0.40	400 KB	✅
Batch	Delete	500,000	1,875	266666.67	0.69	5.68 MB	✅
Batch	Delete	500,000	1,692	295508.27	0.77	7.67 MB	✅
Batch	Insert	500,000	83,215	6008.53	1.29	18.76 MB	✅
Batch	Insert	500,000	83,872	5961.47	1.26	20.46 MB	✅
Batch	Select	500,000	1,073	465983.22	2.79	28.3 MB	✅
Batch	Select	500,000	1,030	485436.89	3.35	28.28 MB	✅
Batch	Update	500,000	67,105	7451.01	2.01	4.12 MB	✅
Batch	Update	500,000	60,292	8292.97	2.17	0 B	✅
Single	Delete	10,000	8,920	1121.08	1.13	3.79 MB	✅
Single	Delete	10,000	9,014	1109.39	0.99	3.71 MB	✅
Single	Insert	10,000	11,063	903.91	0.99	0 B	✅
Single	Insert	10,000	9,460	1057.08	1.16	11.58 MB	✅
Single	Select	10,000	3,452	2896.87	2.51	2.11 MB	✅
Single	Select	10,000	3,480	2873.56	2.96	3.59 MB	✅
Single	Update	10,000	13,863	721.34	0.89	4.68 MB	✅
Single	Update	10,000	12,094	826.86	0.86	10.96 MB	✅

SQLite

操作类型	操作名称	记录数	耗时(ms)	OPS	CPU(%)	内存增量	状态
Aggregation	GroupBy	8	211	4.74	4.31	3.65 MB	✅
Aggregation	GroupBy	8	205	4.88	4.12	0 B	✅
Aggregation	Statistics	500,000	547	10.97	4.28	3.15 MB	✅
Aggregation	Statistics	500,000	544	11.03	4.07	28 KB	✅
Batch	Delete	500,000	974	513347.02	4.61	4.26 MB	✅
Batch	Delete	500,000	982	509164.97	3.91	7.87 MB	✅
Batch	Insert	500,000	47,899	10438.63	4.14	16.37 MB	✅
Batch	Insert	500,000	27,269	18335.84	4.13	6.22 MB	✅
Batch	Select	500,000	5,814	85999.31	4.19	18.05 MB	✅
Batch	Select	500,000	3,045	164203.61	4.06	14.02 MB	✅
Batch	Update	500,000	35,923	13918.66	4.13	25.44 MB	✅
Batch	Update	500,000	34,313	14571.74	4.11	25.03 MB	✅
Single	Delete	10,000	28,162	355.09	3.60	8.72 MB	✅
Single	Delete	10,000	22,679	440.94	3.15	376 KB	✅
Single	Insert	10,000	27,563	362.81	3.50	1.98 MB	✅
Single	Insert	10,000	23,037	434.08	3.25	7.09 MB	✅
Single	Select	10,000	2,256	4432.62	4.24	5.35 MB	✅
Single	Select	10,000	1,052	9505.70	4.08	3.86 MB	✅
Single	Update	10,000	28,824	346.93	3.52	0 B	✅
Single	Update	10,000	23,548	424.66	3.38	8.07 MB	✅

SQLServer

操作类型	操作名称	记录数	耗时(ms)	OPS	CPU(%)	内存增量	状态
Aggregation	GroupBy	8	57	17.54	2.28	700 KB	✅
Aggregation	GroupBy	8	52	19.23	0.00	1.4 MB	✅
Aggregation	Statistics	500,000	116	51.72	1.12	432 KB	✅
Aggregation	Statistics	500,000	120	50.00	0.00	696 KB	✅
Batch	Delete	500,000	24,752	20200.39	0.06	2.53 MB	✅
Batch	Delete	500,000	25,962	19258.92	0.07	7.04 MB	✅
Batch	Insert	500,000	247,844	2017.40	0.09	9.35 MB	✅
Batch	Insert	500,000	255,237	1958.96	0.15	22.93 MB	✅
Batch	Select	500,000	2,623	190621.43	2.03	17.48 MB	✅
Batch	Select	500,000	3,106	160978.75	2.35	6.64 MB	✅
Batch	Update	500,000	285,242	1752.90	0.16	12.74 MB	✅
Batch	Update	500,000	293,971	1700.85	0.20	0 B	✅
Single	Delete	10,000	15,688	637.43	0.48	2.83 MB	✅
Single	Delete	10,000	17,436	573.53	0.49	0 B	✅
Single	Insert	10,000	16,088	621.58	0.45	0 B	✅
Single	Insert	10,000	14,860	672.95	0.44	308 KB	✅
Single	Select	10,000	9,847	1015.54	0.73	4.11 MB	✅
Single	Select	10,000	8,893	1124.48	0.97	260 KB	✅
Single	Update	10,000	27,549	362.99	0.32	4.85 MB	✅
Single	Update	10,000	24,825	402.82	0.38	8.02 MB	✅

CPU 消耗对比 (%)

操作类型	操作名称	MongoDB	MySQL	PostgreSQL	SQLite	SQLServer
Aggregation	GroupBy	0.00	1.07	0.00	4.21	1.14
Aggregation	Statistics	0.10	0.24	0.64	4.18	0.56
Batch	Delete	0.48	0.59	0.73	4.26	0.07
Batch	Insert	1.45	2.27	1.27	4.13	0.12
Batch	Select	1.69	1.50	3.07	4.12	2.19
Batch	Update	1.47	2.06	2.09	4.12	0.18
Single	Delete	1.92	0.52	1.06	3.38	0.48
Single	Insert	1.47	0.60	1.07	3.38	0.45
Single	Select	2.09	1.94	2.73	4.16	0.85
Single	Update	2.02	0.59	0.88	3.45	0.35

内存消耗对比

操作类型	操作名称	MongoDB	MySQL	PostgreSQL	SQLite	SQLServer
Aggregation	GroupBy	44 KB	1.83 MB	304 KB	3.65 MB	1.4 MB
Aggregation	Statistics	748 KB	2.01 MB	848 KB	3.15 MB	696 KB
Batch	Delete	21.63 MB	10.74 MB	7.67 MB	7.87 MB	7.04 MB
Batch	Insert	31.8 MB	17.07 MB	20.46 MB	16.37 MB	22.93 MB
Batch	Select	9.86 MB	12.5 MB	28.3 MB	18.05 MB	17.48 MB
Batch	Update	43.94 MB	5.49 MB	4.12 MB	25.44 MB	12.74 MB
Single	Delete	7.16 MB	120 KB	3.79 MB	8.72 MB	2.83 MB
Single	Insert	6.13 MB	2.35 MB	11.58 MB	7.09 MB	308 KB
Single	Select	892 KB	2.46 MB	3.59 MB	5.35 MB	4.11 MB
Single	Update	12.07 MB	11.42 MB	10.96 MB	8.07 MB	8.02 MB

详细日志

完整的测试日志请查看 logs/benchmark_20251209.log 文件。

---

报告生成时间: 2025-12-09 18:24:49