数据库基准测试报告

January 11, 2026 · View on GitHub

测试时间: 2026-01-11 11:05:26

测试配置

配置项
单次操作记录数1,000
批量操作批次大小1,000
批量操作批次数5
预热迭代次数3
测试迭代次数5

服务器信息

项目
机器名称DESKTOP-RLEON3G
操作系统Microsoft Windows 10.0.19045
OS 架构X64
进程架构X64
处理器数量24
.NET 版本.NET 8.0.22
总内存31.81 GB
采集时间2026-01-11 11:05:26

测试概要

项目
测试数据库MySQL, SQLServer, PostgreSQL
数据库数量3
总测试用例数198
成功用例数198
失败用例数0
成功率100.00%

性能对比总览

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

操作类型操作名称MySQLPostgreSQLSQLServer最快
AggregationGroupBy5.601.0030.20PostgreSQL
AggregationStatistics14.405.4010.00PostgreSQL
BatchDelete89.8018.20236.80PostgreSQL
BatchInsert405.20540.605205.20MySQL
BatchSelect27.007.4014.40PostgreSQL
BatchUpdate343.20378.202730.00MySQL
IndexQueryComplexCondition4498.00296.001454.00PostgreSQL
IndexQueryCompositeIndex_RegionDept180.0061.00201.00PostgreSQL
IndexQueryCompositeIndex_StatusCatPri280.0094.00243.00PostgreSQL
IndexQueryNoIndex_FullScan7185.00579.002590.00PostgreSQL
IndexQueryOrderBy53743.004530.004250.00SQLServer
IndexQueryPagination324.0071.00268.00PostgreSQL
IndexQueryPrefixQuery_Name68208.009325.0015843.00PostgreSQL
IndexQueryPrimaryKey108.0042.00145.00PostgreSQL
IndexQueryRangeQuery_Date857.00128.00236.00PostgreSQL
IndexQueryRangeQuery_Salary1170.00100.00214.00PostgreSQL
IndexQueryRangeQuery_Score1171.0091.00219.00PostgreSQL
IndexQuerySingleIndex_Category166.00121.00111.00SQLServer
IndexQuerySingleIndex_Status168.0070.00462.00PostgreSQL
MillionDataAggregation569.00217.00445.00PostgreSQL
MillionDataGroupBy7873.00209.00115.00SQLServer
MillionDataPrepareData95025.0020588.0027392.00PostgreSQL
SingleDelete3451.40834.001569.40PostgreSQL
SingleInsert3582.40937.401510.40PostgreSQL
SingleSelect1061.60392.801267.20PostgreSQL
SingleUpdate3574.80964.603809.80PostgreSQL

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

操作类型操作名称MySQLPostgreSQLSQLServer最快
AggregationGroupBy216.671000.0033.61PostgreSQL
AggregationStatistics545.341170.00728.57PostgreSQL
BatchDelete56122.10274853.8021225.93PostgreSQL
BatchInsert12365.599894.64962.91MySQL
BatchSelect185388.69678571.43352092.76PostgreSQL
BatchUpdate14852.2613667.681846.18MySQL
IndexQueryComplexCondition22.23337.8468.78PostgreSQL
IndexQueryCompositeIndex_RegionDept555.561639.34497.51PostgreSQL
IndexQueryCompositeIndex_StatusCatPri357.141063.83411.52PostgreSQL
IndexQueryNoIndex_FullScan1.3917.273.86PostgreSQL
IndexQueryOrderBy1.8622.0823.53SQLServer
IndexQueryPagination308.641408.45373.13PostgreSQL
IndexQueryPrefixQuery_Name1.4710.726.31PostgreSQL
IndexQueryPrimaryKey925.932380.95689.66PostgreSQL
IndexQueryRangeQuery_Date116.69781.25423.73PostgreSQL
IndexQueryRangeQuery_Salary85.471000.00467.29PostgreSQL
IndexQueryRangeQuery_Score85.401098.90456.62PostgreSQL
IndexQuerySingleIndex_Category602.41826.45900.90SQLServer
IndexQuerySingleIndex_Status595.241428.57216.45PostgreSQL
MillionDataAggregation14.0636.8717.98PostgreSQL
MillionDataGroupBy0.5119.1434.78SQLServer
MillionDataPrepareData10523.5548571.9836507.01PostgreSQL
SingleDelete289.781199.17638.97PostgreSQL
SingleInsert279.541067.15662.80PostgreSQL
SingleSelect942.642546.04817.75PostgreSQL
SingleUpdate279.861037.11266.57PostgreSQL

各数据库详细结果

MySQL

操作类型操作名称记录数耗时(ms)OPSCPU(%)内存增量状态
AggregationGroupBy81283.335.24236 KB
AggregationGroupBy84250.000.0056 KB
AggregationGroupBy84250.000.00100 KB
AggregationGroupBy84250.0014.754 KB
AggregationGroupBy84250.000.000 B
AggregationStatistics5,00033181.825.77784 KB
AggregationStatistics5,00013461.540.000 B
AggregationStatistics5,0009666.670.000 B
AggregationStatistics5,0008750.000.000 B
AggregationStatistics5,0009666.670.008 KB
BatchDelete5,00010149504.950.64324 KB
BatchDelete5,0008360240.960.0016 KB
BatchDelete5,0008062500.000.00248 KB
BatchDelete5,0009751546.390.00104 KB
BatchDelete5,0008856818.180.73196 KB
BatchInsert5,00044211312.222.2110.35 MB
BatchInsert5,00039012820.513.0011.12 MB
BatchInsert5,00039212755.102.9810.98 MB
BatchInsert5,00039712594.462.9511.11 MB
BatchInsert5,00040512345.683.2110.81 MB
BatchSelect5,00028178571.434.643.37 MB
BatchSelect5,00027185185.194.703.35 MB
BatchSelect5,00026192307.692.464.3 MB
BatchSelect5,00026192307.694.893.37 MB
BatchSelect5,00028178571.432.263.37 MB
BatchUpdate5,00032615337.421.995.8 MB
BatchUpdate5,00039812562.811.802.98 MB
BatchUpdate5,00028717421.602.045.33 MB
BatchUpdate5,00040212437.811.455.39 MB
BatchUpdate5,00030316501.652.145.34 MB
IndexQueryComplexCondition1004,49822.230.209.61 MB
IndexQueryCompositeIndex_RegionDept100180555.562.17500 KB
IndexQueryCompositeIndex_StatusCatPri100280357.140.933.21 MB
IndexQueryNoIndex_FullScan107,1851.390.050 B
IndexQueryOrderBy10053,7431.860.010 B
IndexQueryPagination10,000324308.641.002.01 MB
IndexQueryPrefixQuery_Name10068,2081.470.010 B
IndexQueryPrimaryKey100108925.933.00340 KB
IndexQueryRangeQuery_Date100857116.690.68160 KB
IndexQueryRangeQuery_Salary1001,17085.470.3972 KB
IndexQueryRangeQuery_Score1001,17185.400.397.39 MB
IndexQuerySingleIndex_Category100166602.413.138 KB
IndexQuerySingleIndex_Status100168595.243.105.93 MB
MillionDataAggregation1,000,00056914.060.231.25 MB
MillionDataGroupBy327,8730.510.00124 KB
MillionDataPrepareData1,000,00095,02510523.552.6021.08 MB
SingleDelete1,0003,519284.170.635.56 MB
SingleDelete1,0003,442290.530.643.05 MB
SingleDelete1,0003,387295.250.694.01 MB
SingleDelete1,0003,445290.280.432.82 MB
SingleDelete1,0003,464288.680.583.97 MB
SingleInsert1,0003,852259.610.931.43 MB
SingleInsert1,0003,536282.810.746.69 MB
SingleInsert1,0003,475287.770.516.49 MB
SingleInsert1,0003,554281.370.736.07 MB
SingleInsert1,0003,495286.120.693.64 MB
SingleSelect1,0001,111900.092.113.53 MB
SingleSelect1,0001,036965.251.880 B
SingleSelect1,0001,039962.461.690 B
SingleSelect1,0001,046956.021.930 B
SingleSelect1,0001,076929.372.063 MB
SingleUpdate1,0003,719268.890.720 B
SingleUpdate1,0003,560280.900.57116 KB
SingleUpdate1,0003,554281.370.57176 KB
SingleUpdate1,0003,556281.210.66448 KB
SingleUpdate1,0003,485286.940.691.06 MB

PostgreSQL

操作类型操作名称记录数耗时(ms)OPSCPU(%)内存增量状态
AggregationGroupBy811000.000.008 KB
AggregationGroupBy811000.0036.308 KB
AggregationGroupBy811000.000.008 KB
AggregationGroupBy811000.0033.190 B
AggregationGroupBy811000.000.000 B
AggregationStatistics5,0008750.007.300 B
AggregationStatistics5,00041500.000.000 B
AggregationStatistics5,00051200.000.000 B
AggregationStatistics5,00051200.0024.010 B
AggregationStatistics5,00051200.000.000 B
BatchDelete5,00018277777.780.0032 KB
BatchDelete5,00018277777.787.0216 KB
BatchDelete5,00018277777.780.0016 KB
BatchDelete5,00018277777.783.5616 KB
BatchDelete5,00019263157.890.0016 KB
BatchInsert5,0008725733.941.198.18 MB
BatchInsert5,00047110615.711.2410.92 MB
BatchInsert5,00046010869.571.7011.37 MB
BatchInsert5,00046710706.641.8111.3 MB
BatchInsert5,00043311547.341.9511.29 MB
BatchSelect5,0007714285.710.004 KB
BatchSelect5,0007714285.718.250 B
BatchSelect5,0007714285.710.0012 KB
BatchSelect5,0008625000.007.640 B
BatchSelect5,0008625000.007.330 B
BatchUpdate5,00044311286.681.470 B
BatchUpdate5,00044411261.261.320 B
BatchUpdate5,00040712285.011.122.5 MB
BatchUpdate5,00029516949.151.980 B
BatchUpdate5,00030216556.291.940 B
IndexQueryComplexCondition100296337.840.880 B
IndexQueryCompositeIndex_RegionDept100611639.342.11368 KB
IndexQueryCompositeIndex_StatusCatPri100941063.834.11512 KB
IndexQueryNoIndex_FullScan1057917.270.00444 KB
IndexQueryOrderBy1004,53022.080.030 B
IndexQueryPagination10,000711408.453.660 B
IndexQueryPrefixQuery_Name1009,32510.720.010 B
IndexQueryPrimaryKey100422380.951.5456 KB
IndexQueryRangeQuery_Date100128781.251.02144 KB
IndexQueryRangeQuery_Salary1001001000.002.60984 KB
IndexQueryRangeQuery_Score100911098.901.420 B
IndexQuerySingleIndex_Category100121826.450.544.11 MB
IndexQuerySingleIndex_Status100701428.571.843.86 MB
MillionDataAggregation1,000,00021736.870.00144 KB
MillionDataGroupBy3220919.140.0048 KB
MillionDataPrepareData1,000,00020,58848571.982.3228.98 MB
SingleDelete1,0008331200.481.410 B
SingleDelete1,0008441184.830.930 B
SingleDelete1,0008191221.000.640 B
SingleDelete1,0008411189.061.320 B
SingleDelete1,0008331200.481.640 B
SingleInsert1,0009271078.751.266.79 MB
SingleInsert1,0009661035.201.686.68 MB
SingleInsert1,0009451058.201.036.78 MB
SingleInsert1,0009351069.521.746.79 MB
SingleInsert1,0009141094.091.146.77 MB
SingleSelect1,0003932544.532.324.08 MB
SingleSelect1,0003872583.983.024 MB
SingleSelect1,0003972518.892.624 MB
SingleSelect1,0003962525.253.284 MB
SingleSelect1,0003912557.543.494 MB
SingleUpdate1,0009891011.121.4536 KB
SingleUpdate1,0009801020.411.590 B
SingleUpdate1,0009501052.631.100 B
SingleUpdate1,0009671034.130.870 B
SingleUpdate1,0009371067.241.320 B

SQLServer

操作类型操作名称记录数耗时(ms)OPSCPU(%)内存增量状态
AggregationGroupBy83826.320.0056 KB
AggregationGroupBy82737.042.3352 KB
AggregationGroupBy82934.480.000 B
AggregationGroupBy82934.480.0020 KB
AggregationGroupBy82835.710.0028 KB
AggregationStatistics5,00021285.715.97124 KB
AggregationStatistics5,0007857.140.000 B
AggregationStatistics5,0008750.000.000 B
AggregationStatistics5,0008750.007.6220 KB
AggregationStatistics5,00061000.009.371.54 MB
BatchDelete5,00027218382.350.7220 KB
BatchDelete5,00022722026.430.001.75 MB
BatchDelete5,00023321459.230.000 B
BatchDelete5,00023021739.130.000 B
BatchDelete5,00022222522.520.000 B
BatchInsert5,0005,513906.950.124.4 MB
BatchInsert5,0005,342935.980.122.79 MB
BatchInsert5,0005,174966.370.042.44 MB
BatchInsert5,0005,239954.380.074.03 MB
BatchInsert5,0004,7581050.860.082.72 MB
BatchSelect5,00016312500.000.00232 KB
BatchSelect5,00013384615.389.3712 KB
BatchSelect5,00013384615.384.7464 KB
BatchSelect5,00017294117.653.690 B
BatchSelect5,00013384615.380.00384 KB
BatchUpdate5,0002,4792016.940.115.02 MB
BatchUpdate5,0003,0061663.340.094.02 MB
BatchUpdate5,0003,0221654.530.154.61 MB
BatchUpdate5,0002,6831863.590.053.86 MB
BatchUpdate5,0002,4602032.520.134 MB
IndexQueryComplexCondition1001,45468.780.0912 KB
IndexQueryCompositeIndex_RegionDept100201497.511.612.45 MB
IndexQueryCompositeIndex_StatusCatPri100243411.521.603.83 MB
IndexQueryNoIndex_FullScan102,5903.860.0388 KB
IndexQueryOrderBy1004,25023.530.060 B
IndexQueryPagination10,000268373.130.972.96 MB
IndexQueryPrefixQuery_Name10015,8436.310.010 B
IndexQueryPrimaryKey100145689.660.453.21 MB
IndexQueryRangeQuery_Date100236423.730.832.28 MB
IndexQueryRangeQuery_Salary100214467.290.611.19 MB
IndexQueryRangeQuery_Score100219456.621.482.2 MB
IndexQuerySingleIndex_Category100111900.900.581.62 MB
IndexQuerySingleIndex_Status100462216.450.422 MB
MillionDataAggregation1,000,00044517.980.002.16 MB
MillionDataGroupBy3211534.780.00216 KB
MillionDataPrepareData1,000,00027,39236507.011.0669.81 MB
SingleDelete1,0001,712584.110.30608 KB
SingleDelete1,0001,589629.330.82148 KB
SingleDelete1,0001,484673.850.440 B
SingleDelete1,0001,578633.710.4124 KB
SingleDelete1,0001,484673.850.6620 KB
SingleInsert1,0001,606622.670.576.43 MB
SingleInsert1,0001,517659.200.266.63 MB
SingleInsert1,0001,473678.890.496.79 MB
SingleInsert1,0001,488672.040.486.79 MB
SingleInsert1,0001,468681.200.846.79 MB
SingleSelect1,0001,610621.120.731.39 MB
SingleSelect1,0001,463683.530.673 MB
SingleSelect1,0001,017983.280.903 MB
SingleSelect1,0001,241805.800.682.4 MB
SingleSelect1,0001,005995.020.653 MB
SingleUpdate1,0003,729268.170.262.53 MB
SingleUpdate1,0004,538220.360.331.61 MB
SingleUpdate1,0003,308302.300.22972 KB
SingleUpdate1,0004,156240.620.162.98 MB
SingleUpdate1,0003,318301.390.223.04 MB

CPU 消耗对比 (%)

操作类型操作名称MySQLPostgreSQLSQLServer
AggregationGroupBy4.0013.900.47
AggregationStatistics1.156.264.59
BatchDelete0.272.120.14
BatchInsert2.871.580.09
BatchSelect3.794.643.56
BatchUpdate1.881.570.11
IndexQueryComplexCondition0.200.880.09
IndexQueryCompositeIndex_RegionDept2.172.111.61
IndexQueryCompositeIndex_StatusCatPri0.934.111.60
IndexQueryNoIndex_FullScan0.050.000.03
IndexQueryOrderBy0.010.030.06
IndexQueryPagination1.003.660.97
IndexQueryPrefixQuery_Name0.010.010.01
IndexQueryPrimaryKey3.001.540.45
IndexQueryRangeQuery_Date0.681.020.83
IndexQueryRangeQuery_Salary0.392.600.61
IndexQueryRangeQuery_Score0.391.421.48
IndexQuerySingleIndex_Category3.130.540.58
IndexQuerySingleIndex_Status3.101.840.42
MillionDataAggregation0.230.000.00
MillionDataGroupBy0.000.000.00
MillionDataPrepareData2.602.321.06
SingleDelete0.591.190.53
SingleInsert0.721.370.53
SingleSelect1.932.950.73
SingleUpdate0.641.270.24

内存消耗对比

操作类型操作名称MySQLPostgreSQLSQLServer
AggregationGroupBy236 KB8 KB56 KB
AggregationStatistics784 KB0 B1.54 MB
BatchDelete324 KB32 KB1.75 MB
BatchInsert11.12 MB11.37 MB4.4 MB
BatchSelect4.3 MB12 KB384 KB
BatchUpdate5.8 MB2.5 MB5.02 MB
IndexQueryComplexCondition9.61 MB0 B12 KB
IndexQueryCompositeIndex_RegionDept500 KB368 KB2.45 MB
IndexQueryCompositeIndex_StatusCatPri3.21 MB512 KB3.83 MB
IndexQueryNoIndex_FullScan0 B444 KB88 KB
IndexQueryOrderBy0 B0 B0 B
IndexQueryPagination2.01 MB0 B2.96 MB
IndexQueryPrefixQuery_Name0 B0 B0 B
IndexQueryPrimaryKey340 KB56 KB3.21 MB
IndexQueryRangeQuery_Date160 KB144 KB2.28 MB
IndexQueryRangeQuery_Salary72 KB984 KB1.19 MB
IndexQueryRangeQuery_Score7.39 MB0 B2.2 MB
IndexQuerySingleIndex_Category8 KB4.11 MB1.62 MB
IndexQuerySingleIndex_Status5.93 MB3.86 MB2 MB
MillionDataAggregation1.25 MB144 KB2.16 MB
MillionDataGroupBy124 KB48 KB216 KB
MillionDataPrepareData21.08 MB28.98 MB69.81 MB
SingleDelete5.56 MB0 B608 KB
SingleInsert6.69 MB6.79 MB6.79 MB
SingleSelect3.53 MB4.08 MB3 MB
SingleUpdate1.06 MB36 KB3.04 MB

详细日志

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


报告生成时间: 2026-01-11 11:05:26